RE: [PHP] [OT MySQL] Syntax for selecting within a range of time from database
| From: | Jay Blanchard | Date: | Thu, 04 Dec 2003 12:51:02 +0000 |
| Subject: | RE: [PHP] [OT MySQL] Syntax for selecting within a range of time from database | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-171811@lists.php.net to get a copy of this message | ||
[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)