SQL search date range

[sethcox]

I am storing dates in a database by date("Y-m-d").

I need to search for every record in the database added within the last 7 days - right now I have it bringing up only today:

mysql_query("SELECT * FROM request WHERE dte = '$today' AND public = 'y' ORDER BY ID desc",$db);

How can i tell it to show me where dte = today and everday back to 7 days ago?

Thanks!

[steved]

Use the date() function to build your two date variables. Then the sql would just need to do something like:

Select * from request where dte between '$today' and '$startdate' and public = 'y'

[sethcox]

That did it - thank you very much!