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.)
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... ;)
-- ---John Holmes...
Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/
php|architect: The Magazine for PHP Professionals – www.phparch.com
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
