in between dates
Posted: Mon Jul 10, 2006 7:37 am
Hi
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 :
I know this is wrong, could anyone give me some tips?
Thanks in advance
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