Mark Hensler — Tue, 19 Nov 2002 07:20:58 +0000

don't use PHP... too much coding... throw the extra work at the SQL server...

SELECT * FROM table_name WHERE TO_DAYS(start_date) >= TO_DAYS(NOW())-7

SELECT * FROM table_name WHERE ADDDATE(NOW(), INTERVAL -7 DAY) >= start_date

I'm assuming that start_date is a date, datetime, or timestamp data type field.

joyce — Tue, 19 Nov 2002 06:50:29 +0000

yes...how to do tat?

zollet — Tue, 19 Nov 2002 06:43:25 +0000

It's not that hard with PHP, are you using PHP?

joyce — Tue, 19 Nov 2002 06:29:48 +0000

yes..in my database i only store the start date...but how am i going to select out the promotion if the date is still within the 7 days??

Mark Hensler — Tue, 19 Nov 2002 05:25:14 +0000

I'm a bit lost.

I'm guessing that you want to select a start date. Calculate the duration of a promotion (start date + 7 days). I'm not sure what you want to check for validity.