----- Original Message -----
From: Russ Michell <[EMAIL PROTECTED]>
Sent: Wednesday, August 22, 2001 10:16 PM
Subject: [PHP-DB] Query construction (again)

> Hey there folks - similar problem - different project!
> I want to select some records for a period of 7days after their insert
[dateFrom] date.
> Last time I asked you guys for help I was helped toward the following
> $sql = "SELECT * FROM $Tpostings WHERE now()>=dateFrom AND now()<dateTo";
> The problem in this new project is that the 'dateTo' field is not included
in the DB. It is 7-days
> after 'dateFrom'. So why does the following query not work:
> $sql = "SELECT * FROM $tabitem WHERE DATE_ADD(submitDate, INTERVAL 7
> No error is received though...

There is no comparison in your WHERE clause. Try something like:

$sql = "SELECT * FROM $tabitem WHERE DATE_ADD(submitDate, INTERVAL 7 DAY) =

Depending on how the date is stored (date + time, or just date) you may have
to modify the output of now() to match.

Jason Wong
Gremlins Associates

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to