I have some news articles in my mysql db. I want to display all the articles posted up in the past month. I know how to get todays date - date("d m Y"), but how can I find out the date a month ago? Once I have that, I guess the sql will be something like "SELECT * FROM news WHERE newsDate >= {whatever 30 days ago was}"
The field is a TimeStamp with default value of current date. Its stored in this format - 2008-11-10 12:10:02