RE: [PHP] [OT MySQL] Syntax for selecting within a range of time from database

[Jay Blanchard]

[snip]
        SELECT date(?) FROM table WHERE DATE_ADD(now(?), INTERVAL 72
HOURS)
[/snip]

careful of keywords

SELECT dateThing FROM table WHERE dateThing BETWEEN NOW() AND
DATE_ADD(NOW(), INTERVAL 72 HOUR)

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php