Entry

How can I select all rows that have a date column more than one week old?

Sep 17th, 1999 01:40
Nathan Wallace, Chris Cosentino

Well, if you are using MySQL and you have a field with a DATE type that 
you want to run a query against, you can do something like this:

    $query = mysql_query("select * from news where
                          (to_days(now())-to_days(news.date))>='7'");
    while ($myrow = mysql_fetch_array($query)) {
        #Do stuff to $myrow...
    }