RE: [PHP-DB] mysql - php DATE QUESTION...
| From: | Rick Emery | Date: | Wed, 03 Oct 2001 13:22:41 +0000 |
| Subject: | RE: [PHP-DB] mysql - php DATE QUESTION... | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-12965@lists.php.net to get a copy of this message | ||
Check the MySQL manual DATE/TIME functions.
try: DELETE FROM mytable WHERE date_column < ( CURRDATE()-30 )
-----Original Message-----
From: Koutsogiannopoulos Karolos [mailto:k.koutsogiannopoulos@ideal.gr]
Sent: Wednesday, October 03, 2001 7:41 AM
To: 'Php-Db (E-mail)
Subject: [PHP-DB] mysql - php DATE QUESTION...
Can someone offer some help...?
Lets say i have a date collumn in a mysql table that includes dates that get
stored each time i enter an entry...
How can i check when i enter the page that displays the entries to delete
all entries older than 30 days?
thanks.