Re: Searching with Date Ranges

From:	John W. Holmes	Date:	Fri, 12 Sep 2003 00:45:48 +0000
Subject:	Re: Searching with Date Ranges
References:	1	Groups:	php.general
Request:	Send a blank email to php-general+get-162362@lists.php.net to get a copy of this message

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.)

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