sorry for misspelling: curdate()
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 03, 2001 8:23 AM
To: 'Koutsogiannopoulos Karolos'
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] mysql - php DATE QUESTION...
Check the MySQL manual DATE/TIME functions.
try: DELETE FROM mytable WHERE date_column ( CURRDATE()-30 )
-Original Message-
From: Koutsogiannopoulos Karolos [mailto:[EMAIL PROTECTED]]
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.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]