Data to display for specific time period

[wndyw1]

I am attempting to put some information on my website. For a specified period of time, I would like to display data, such as photos, links, event dates, etc.

My database table contains the data, link for example, a start and an ending date. I cannot figure out how to write the script to display the data for a certain amount of time and then automatically change the data at a specified date.

Thanks, any help is appreciated.

[physics]

Basically I think you want to require in the mysql query something like

WHERE $date >= start_date AND $date <= end_date

where $date is today's date.

[coopster]

And don't forget that DATE column type values need to be enclosed in quotation marks ...