John W. Holmes wrote:
Seth Willits wrote:
If I want to show events (records in a MySQL table) for the next 10 days (and I do), what would be the best approach to searching with this range? (The dates in my table are stored as a string in the format YYYY/MM/DD.)
And change the column type to DATE!!!
SELECT * FROM Table WHERE event_date BETWEEN NOW() AND NOW() + INTERVAL 10 DAY;
"Read the book! Be patient! All success comes from acquiring knowledge and experience."
-- Seth Willits
You quote yourself in your own signature? Isn't that... illegal or something... ;)
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
