Garbage Collection

From: Date: Sat, 03 Feb 2001 09:05:07 +0000
Subject: Garbage Collection
Groups: php.db 
Request: Send a blank email to php-db+get-6337@lists.php.net to get a copy of this message
I am writing a PHP script that accesses a MYSQL database when the adminstrator (the client) wants to add something to a calendar (dynamically PHP generated). I have written the callendar and have the whole thing setup to be able to update it regularly, through a easy user interface on the adminstration page. The problem that I am forseeing though is that, the person I am doing this for is going to keep adding information to the calendar thereby adding more rows to the database, and never deleting any of it. Since this is a calendar, I thought I might right some sort of "Garbage Collector" deletes old information on the first of the month. The way I would have to do this though, is it to go through all the fields, parse the Date field, and check to see if the date is less than the current. My question is, is there a faster way to do this. Mabye some MYSQL built in function that I am missing or something. Any help would be appreciated. -- ------------------------------------- Clayton Bluhm Computer Engineering Student Email: nashirak@mindspring.com (home) gte501v@prism.gatech.edu (school)

« previous php.db (#6337) next »