Go Back   CodingForums.com > Search Forums
Reload this Page Search Results

Before you post, read our: Rules & Posting Guidelines

Page 1 of 20 1 2311 Last »
Showing results 1 to 25 of 500
Search took 4.26 seconds. Search: Posts Made By: guelphdad
Forum: MySQL 02-14-2013, 04:56 PM
Replies: 2
Views: 392
Posted By guelphdad
See the manual for JOINs.

See the manual for JOINs.
Forum: MySQL 02-11-2013, 12:31 AM
Replies: 4
Views: 584
Posted By guelphdad
what have you tried? you can specify...

what have you tried? you can specify DAYOFWEEK(yourdatefield) to get the day of week from the date or datetime entered.
Forum: MySQL 01-21-2013, 06:33 PM
Replies: 10
Views: 649
Posted By guelphdad
To use two tables you'd have to use a JOIN or a...

To use two tables you'd have to use a JOIN or a UNION. You have given us fake columns so all we can do is guess. Giving clear examples would actually get you a better answer.
Forum: MySQL 11-30-2012, 03:32 PM
Replies: 4
Views: 499
Posted By guelphdad
You are missing the columns storeid and itemcode...

You are missing the columns storeid and itemcode in the Orders table.
You actually have to create them in order to make a foreign key on them.

there is also no data type of IDENTITY in mysql. I...
Forum: MySQL 11-29-2012, 02:35 PM
Replies: 9
Views: 875
Posted By guelphdad
PHP code isn't necessary. You've asked a mysql...

PHP code isn't necessary. You've asked a mysql question and been given a mysql answer without regard to the front end application (the two don't have to be used together in other words).

If you...
Forum: MySQL 11-21-2012, 01:59 PM
Replies: 12
Views: 1,063
Posted By guelphdad
No matter who is in the White House, if they can...

No matter who is in the White House, if they can blame the DEBT on the other guy you'll find lots of posts, if the DEBT is their fault.... not so much.

Happens in Canada too! :)
Forum: MySQL 11-15-2012, 07:26 PM
Replies: 6
Views: 579
Posted By guelphdad
Again the suggestion is DON'T use PHP at all.

Again the suggestion is DON'T use PHP at all.
Forum: MySQL 11-09-2012, 06:23 PM
Replies: 2
Views: 377
Posted By guelphdad
ORDER BY messagetypecolumn LIMIT 5 ...

ORDER BY
messagetypecolumn
LIMIT
5


why the need to send only 5 messages at a time?
Forum: MySQL 11-07-2012, 02:34 PM
Replies: 40
Views: 2,257
Posted By guelphdad
Do neither. have your products table and remove...

Do neither.
have your products table and remove the image column.

create an images table with two columns
imageid, pathtoimage

create a third table product_images with two columns
productid,...
Forum: MySQL 11-06-2012, 06:38 PM
Replies: 40
Views: 2,257
Posted By guelphdad
If you manually enter no you won't have to trap...

If you manually enter no you won't have to trap errors as when you enter an incorrect amount you would see the error right afterwards.

DECIMAL(5,2) means a value of five digits with two of those...
Forum: MySQL 11-06-2012, 01:56 PM
Replies: 40
Views: 2,257
Posted By guelphdad
It doesn't need to be unsigned, but you could do...

It doesn't need to be unsigned, but you could do that as you are unlikely to need negative prices.

use DECIMAL(5,2) which will allow prices up to 999.99 note you will have to trap any errors for...
Forum: Other Databases 10-25-2012, 09:19 PM
Replies: 3
Views: 1,742
Posted By guelphdad
crewson, your question has nothing to do with...

crewson, your question has nothing to do with this thread please start a separate thread.
Forum: MySQL 10-22-2012, 10:19 PM
Replies: 7
Views: 1,663
Posted By guelphdad
I always wonder why people create columns that...

I always wonder why people create columns that are NOT NULL and then assign an empty string as the default value. Why bother?
Forum: MySQL 10-22-2012, 04:22 PM
Replies: 7
Views: 920
Posted By guelphdad
which database application are you using? All of...

which database application are you using? All of them use SQL but syntax is different among databases.

also providing sample data and expected results will also help those you are asking to assist...
Forum: Other Databases 10-19-2012, 06:07 PM
Replies: 8
Views: 1,154
Posted By guelphdad
You can't get an answer to your question because...

You can't get an answer to your question because you are not clear enough in what you are asking.

Please provide an example of what you actually want answered. There can be a number of answers,...
Forum: MySQL 10-19-2012, 06:05 PM
Replies: 4
Views: 719
Posted By guelphdad
This error likely means you are using an auto...

This error likely means you are using an auto increment on a TINYINT column type. You have reached 127 rows inserted (even if you have deleted some) so the next row is trying to insert a value of 127...
Forum: MySQL 10-19-2012, 02:01 PM
Replies: 1
Views: 461
Posted By guelphdad
Yes, normalize your data. Multiple values do not...

Yes, normalize your data. Multiple values do not belong in a single column.
Forum: MySQL 10-19-2012, 01:12 PM
Replies: 16
Views: 6,481
Posted By guelphdad
Indeed they do and they've even answered it in...

Indeed they do and they've even answered it in this two year old thread you've resurrected. Don't store multiple values in a single column. Instead normalize your data.
Forum: MySQL 10-17-2012, 12:29 PM
Replies: 1
Views: 461
Posted By guelphdad
last_insert_id

last_insert_id
Forum: MySQL 10-16-2012, 08:50 PM
Replies: 8
Views: 585
Posted By guelphdad
no, as i said above a few hundred million rows is...

no, as i said above a few hundred million rows is a big table. Properly indexed, a search on a 250,000 row table on a basic query, you should be talking under 1 second.
Forum: MySQL 10-16-2012, 07:08 PM
Replies: 8
Views: 585
Posted By guelphdad
really? what is huge? several hundred million...

really? what is huge? several hundred million rows maybe. how long would that take you to get to? I think you are over thinking.
Forum: MySQL 10-16-2012, 05:27 PM
Replies: 8
Views: 585
Posted By guelphdad
why would there be a problem storing a new entry...

why would there be a problem storing a new entry for every log in?
Forum: MySQL 10-15-2012, 06:52 PM
Replies: 14
Views: 900
Posted By guelphdad
Perhaps I wasn't clear then. What I meant was...

Perhaps I wasn't clear then. What I meant was perhaps you were passing the string 'apples' when you needed to pass SHA1('apples') to match what was in the table.

Glad you have it figured out.
...
Forum: MySQL 10-15-2012, 06:48 PM
Replies: 7
Views: 479
Posted By guelphdad
So don't you think you need CARTDATA = yourstring...

So don't you think you need CARTDATA = yourstring perhaps? and without CARTDATA being there you are getting an error message?
Forum: MySQL 10-15-2012, 02:26 PM
Replies: 7
Views: 479
Posted By guelphdad
Okay I'll give you a broader hint. Apples has to...

Okay I'll give you a broader hint. Apples has to be equal to something like a column perhaps.
Showing results 1 to 25 of 500
Page 1 of 20 1 2311 Last »

 
Forum Jump

All times are GMT +1. The time now is 10:43 AM.