Re: PHP/MySQL date < CURDATE() problem

[Greg Platt]

Okay, I'm guessing again, but if date is defined in your table as "int(10) unsigned" then it's actually a NUMERIC unix date which contains all the following data: "yyyy-mm-dd hh:mm:ss" whereas, curdate() appears to be a STRING function. I'll bet MySQL gets confused about what to do when trying to compare an unformatted numeric value to a STRING and that's why your date compaarison produces inderterminate results.

Try this select and see if it doesn't work correctly:

SELECT * FROM events WHERE left(from_unixtime(date),10) <= CURDATE() ORDER BY date LIMIT 7;

If I'm right, I'll bet you get ONLY the rows that happened BEFORE today...



Edited 1 time(s). Last edit at 12/28/2007 01:59PM by Greg Platt.