> I have a start_date and a finish_date stored in a mysql db.
>
> I want to check that today's date falls between these 2 dates.
>
> Can I set up the 3 dates so that a simple subtraction can be done? eg
>
> if (($today - $start > 0) && ($finish - $today >0)) {
> ...within range...
> } else {
> ...out of range...
> }
>
> I can't seem to find date functions that are of any use for this.
I could have sworn I already answered this today...
SELECT ... FROM table WHERE CURDATE() BETWEEN start AND end
Where 'start' and 'end' are your columns...
It's slightly faster to use CURDATE() > start AND CURDATE < end, but I
find BETWEEN easier to read...
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
