SELECT * FROM database WHERE (TO_DAYS(dateadded)-TO_DAYS(Now())>=-30)  ORDER BY dateadded DESC, ID DESC

##</code><code>##

/search.pl?searchtextterms=&andor=AND&search=yes&state=(TO_DAYS(dateadded)-TO_DAYS(Now())%3E=-30)&currentpage=2