Date Query

[alex_samanta]

Hello,

Here is the query that I use on my site to retrieve the news from the database:

SELECT * FROM news WHERE TO_DAYS(NOW()) - TO_DAYS(storydate) <= 2 ORDER BY storyid DESC

The problem that I'm having with this is that it only retrieves the news for the last three days based upon the current day.

I would like to know how to have a query that will retrieve the news for the last three days that are in the database. There might be about 8-10 postings per day, so I would like to retrieve all news for the latest three days that are in the database.

Thanks

[Anon]

Hmm. replace TO_DAYS(NOW()) with, um, MAX(TO_DAYS(storydate))?