PHP, dates, and MySQL data comparisons
| From: | Joseph Szobody | Date: | Wed, 02 Oct 2002 02:32:23 +0000 |
| Subject: | PHP, dates, and MySQL data comparisons | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-22144@lists.php.net to get a copy of this message | ||
I have a table with a Date field (yyyy-mm-dd) and I would like to retrieve all rows with the date
less than one week ago.
Something like.... SELECT FROM table WHERE date > one_week_ago_today.
This seems like it should be so simple... yet I'm not getting it.
Any help is appreciated.
Thanks,
Joseph