I am looking to return a list of news articles published from the last 10 days.
What I want to do is run a query that pickas out all news articles within between today and 10 days before.
I am using a query in my script to do this which looks like this :
Code: Select all
$result = mysql_query("Select * from news where news_date between now() - 10 AND now()");Thanks in advance