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

[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.n

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

PHP Gurus, What I'm trying to accomplish can be done in PHP, but someone on this list told me once that it's far more efficient to try and do as much on the MySQL side as possible. But I'm not really enough of an SQL guy to join an SQL list, so I hope I can be forgiven this posting here.