hi

I'm trying to fugure out a query that will select records from within a range of two dates using MySQL.

The data I'm trying to represent is for a news page on a website. so I want to have 'current stories' i.e. those from the past 30 days. I'd then like to list the stories that are 30-60 days old and anything else would be in an archive.

I have this query for the 0-30 day old stories:

SELECT headline, dateposted, newsID, flag
FROM news
WHERE newstype = 9 AND flag = 0 And DATE_ADD(CURDATE(), INTERVAL -30 DAY) <=dateposted
ORDER BY dateposted

this works well, my problem is I can't find any document for choosing data that's between x and y days old.

can anyone help?

Have you tried the To_days function?
It goes something like this


SELECT dateposted, to_days(now())
- TO_DAYS(dateposted)
AS NumDays
FROM news

NumDays will give you how old the article is going back from today's date

so to get a range you would use

SELECT dateposted, to_days(now()) - TO_DAYS(dateposted) AS NumDays
FROM news
where to_days(now()) - TO_DAYS(dateposted) between 30 and 60

hope this helps
Karen

Yes this is the method I used to solve it...

thanks anyway.

I should've said I'd solved my problem on my own... bit too busy sorry.

Ah, but now I've learned how to do it, too. Thank you both!
--ST

Glad it helped !