mysql - Show most viewed entries that have been added in the last 7 days

Question

I want to show the most viewed entries that have been added in the last 7 days.

I've tried:

SELECT active, date_created, comments, views, URL, title, category, image1
FROM `tbl_news` 
WHERE DATE_SUB(curdate(), INTERVAL 1 WEEK) <= `date_created` 
ORDER BY `views` DESC LIMIT 10;

But with no success.

The date is in the standard format: 1310824884

Answer 1

How about

SELECT active, date_created, comments, views, URL, title, category, image1
FROM `tbl_news`
WHere DATE_SUB > (curdate() - 604800)
ORDER BY `views` DESC
LIMIT 10