testing datetimes
Posted: Sun Mar 29, 2009 4:06 pm
Im having a rough time with dates in php and mysql, whats the best way to write a query along these lines...
SELECT *
FROM table
WHERE datefield = today
and then
SELECT *
FROM table
WHERE datefield = past 3 days not including today
all my dates are stored in DATETIME format.
Thanks for the help, john
SELECT *
FROM table
WHERE datefield = today
and then
SELECT *
FROM table
WHERE datefield = past 3 days not including today
all my dates are stored in DATETIME format.
Thanks for the help, john