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. <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>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.
--
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]
