Re: Problem loading records between 2 dates...

[Felix Geerinckx]

[Your question has nothing to do with MySQL Transactions. Please choose a more appropriate forum next time (e.g. newbie)]

Andrew Stokes wrote:

> SELECT id,subject,date,type,category,numreads,keywords
> FROM User1
> WHERE date BETWEEN '2/5/2006 1:48:46 AM' AND Now() AND type >= '1'

Your datetime literals should be in 'yyyy-mm-dd hh:mm:ss' format.
You can use the STR_TO_DATE() function to convert if necessary.
See http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

--
felix
Please use BBCode to format your messages in this forum.