Results 1 to 2 of 2
Thread: Display items older than 6months
Dec 2, 2009, 04:55 #1
Display items older than 6months
I'm trying to display news items older than 6 months old:
I've got this code but not sure where I'm going wrong.
ORDER BY news_date DESC
WHERE news_date >= #now()# INTERVAL 6 MONTH
Any pointers would be appreciated!
Dec 2, 2009, 05:33 #2
Start by putting the ORDER BY after the WHEREGuido - Community Team Leader
The Votes Are In: The Winners of the 2013 Community Awards are...
Blog - Free Flash Slideshow Widget