Results 1 to 2 of 2
Thread: Display items older than 6months
Dec 2, 2009, 03: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, 04:33 #2
Start by putting the ORDER BY after the WHEREGuido - Community Team Leader
The 2013 SitePoint Awards - Nominate your heroes now!
Thinking Web: Voices of the Community
Blog - Free Flash Slideshow Widget