RE: [PHP-DB] delete registers..

Depends on what registers are. If they are people then I would just shoot then and get it over with. :) Seriously, if you mean how do you delete records form a table that are more than a month old (let's say 30 days to make it simply) then you need to have a timestamp field in your table. Then in a nightly sweep, delete from table where today - timestamp_filed>30. HTH, Cal http://www.calevans.com -----Original Message----- From: Romeo Manzur [mailto:rmanzur@isilicom.com.mx] Sent: Friday, March 23, 2001 9:44 AM To: php-db@lists.php.net Subject: [PHP-DB] delete registers.. How could I automatly delete registers from a table that have a month old??? -- -------------------------------------- Romeo Manzur Web Application Developer iSilicom Av. 27 de Febrero 904-A Desp 1, Centro C.P.:86000 Villahermosa, Tabasco, Mexico Tel.:(52)(9)3-12-4790 -------------------------------------- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net