Pulling data from a MySQL database with PHP date code??

[Wild Child]

Hi,
I am trying to find ways to retrieve data by date from a mysql database.
What I would like to do is to have the option for people to retrieve a file
that was entered in the week before the current day (something like click
here for all drinks added in the last week) I have tried to make this code
work, the only way I can is to manually change the date every day, I would
like it to do it automatically.

Thanks,
Wild Child

[Tom Thackrey]

On 11-Jan-2004, "Wild Child" <In**@Bar-Guide.ca> wrote:

I am trying to find ways to retrieve data by date from a mysql
database.
What I would like to do is to have the option for people to retrieve a
file
that was entered in the week before the current day (something like click
here for all drinks added in the last week) I have tried to make this
code
work, the only way I can is to manually change the date every day, I would
like it to do it automatically.

assuming you have a column called date in you table

select * from tablename where date<date_sub(now(),interval 7 day)

--
Tom Thackrey
www.creative-light.com
tom (at) creative (dash) light (dot) com
do NOT send email to ja*********@willglen.net (it's reserved for spammers)