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:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 9:44 AM
To: [EMAIL PROTECTED]
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: [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]

Reply via email to