I would probably recommend AGAINST running this php script from cron. I have a similar script but I use a PERL version for auto-updates.
PHP should only (IMHO) be used where someone will see some output on a webpage. Other advantage of using PERL is that you could easily create a log file by redirecting the output (or PRINT statements) to a file using simple redirection (> and >>) instead of having to actually manipulate the file. Just my tuppenceworth. David -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jonathan Hilgeman Sent: 20 December 2001 19:22 To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [mysql-support] RE: [PHP-DB] Run php page automatically I usually just create a cron job for this. Create your PHP script that will delete the matching records once. Then go into cron and have it run every 10 minutes. - Jonathan -----Original Message----- From: Harpreet [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 20, 2001 11:21 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP-DB] Run php page automatically I would like to create a php page that would automatically run every 10 minutes or so to delete records from a table. This table has an expiration field and records r tested by comparing current date with the expiration date and record is deleted if expired. Is this possible. Help is greatly appreciated. I am using php for my application. I am working on a LInux server and using mysql as my database. regards, Harpreet Kaur Software Developer Crispin Corporations Inc. -- 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] _______________________________________________ To unsubscribe yourself from this list please go to http://www.mysql.org/mailman/listinfo/support and read the unsubscription information. support mailing list [EMAIL PROTECTED] http://www.mysql.org/mailman/listinfo/support -- 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]
