Date syntax question

[Anon]

Hello

New to PHP and mySQL if I'm in the wrong place please send me to the right one.

Using PHP3 and mySQL I want to create a drop down box (preferably a drop down but doesn't have to be) with the user being able to query the database for entries for the previous 2,4,7,15, or 30 days.

The options on the drop down box (or links on the page) would be just that, 2,4,7... I'm wondering what the SQL statement would be for this or if it's possible.

Thanks

Richard

[Anon]

Assuming $days contains the selected request and date_field is the mysql field containing the concerned date.

select * from tablename where adddate(date_field,interval $days day)>now();

Check out all the VERY useful mysql date/time functions in the mysql manual.

They make life so much simpler ;-)

[Anon]

Ok, thanks for your patience. Your example helps clarify matters. I'm still in a blurry stage of all this.

Thanks again,

Richard