Re: MySQL DB CleanUp Help!

Or of course one could compile PHP as a standalone and simply cron the script itself. No matter how PHP is invoked, though, IMHO scripts like this that require no human interaction should be a bit more robust than interactive systems. For example, one would probably want to code it to make sure the two instances of the same script cannot run simultaneously (and if an instance tries to run simultaneously, it should send an email to the admin and quit instead of performing its duties). Also error checking should email problems to the admin. As an alternative to emailing the admin, you could log status messages and errors to syslog or a file or a db table. Good luck! Doug At 03:30 PM 8/23/01 +0800, Jason Wong wrote: >----- Original Message ----- >From: Arcadius A. <ahouans@sh.cvut.cz> >To: <php-db@lists.php.net> >Sent: Thursday, August 23, 2001 9:28 PM >Subject: [PHP-DB] MySQL DB CleanUp Help! > > >> Hello ! >> I'd like to automatically delete old entries from my MySQL .... ...[snip]... >> Arcad. > >Here's one way to do it: > >Create a php page which when accessed will do deletions you require. >Create a cron job which uses wget to access that page. > >regards >-- >Jason Wong >Gremlins Associates >www.gremlins.com.hk > --Doug's Signature File---------------------------------------- ~ ~ ~ I'm proud to work for GLISnet, Michigan's best ISP ~ ~ ~ --1.888.445.4763---8am to 8pm every day---http://www.glis.net-- The views and opinions expressed in this email are my own and may not be those of my employer.