Select date problem... 1

[Elliott3]

What i want to do is get the records that are greater than or equal to a certain date:
$strSQL = "select * from mytable where date >=" . $date;

I think that the above is just comparing the string $date to the date. The database is mySQL. Can someone let me in on the big secret? lol

CES

 

[sleipnir214]

That should work. Provided that you are giving MySQL a date string that it can understand. The only date format MySQL understands for input is YYYY-MM-DD (and possibly YYYY/MM/DD).

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[sleipnir214]

ADDENDUM:

Date strings are strings. They must be enclosed in singlequotes.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[Elliott3]

thanks sleipnir214...it was the signle quotes

CES