[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