[thelist] Expiring records in MySQL

John Corry webshot at members.evolt.org
Fri May 10 15:45:01 CDT 2002


> Daniel
>
> As far as I know this isn't possible.
> However (I'm assuming you're running on unix), you could set
> up a daily cron job...

Or, you could include a function in the script that updates/queries the
database so that the first thing that happens is that all records more
than x days old are deleted.

If you don't want to run that every time the page loads, you could put
it in a if(today == Monday) or whatever...

As long as users load the page, the database maintenance gets done...

jpc




More information about the thelist mailing list