how to make this script work...

From: Date: Tue, 29 Apr 2003 04:25:37 +0000
Subject: how to make this script work...
Groups: php.general 
Request: Send a blank email to php-general+get-145586@lists.php.net to get a copy of this message
hi.. i have this script: <?php include("conf.inc"); mysql_connect($host, $mysqluser, $mysqlpwd)||die(mysql_error()); mysql_select_db($db)||die(mysql_error()); mysql_query("select count(*) from prayer"); $total=mysql_affected_rows(); mysql_query("delete from prayer where Posted <= now()-interval 14 day"); $delete=mysql_affected_rows(); $status1=mysql_query("select version() as version, connection_id() as connection, now() as time, benchmark(1, \"delete from prayer where Posted <= now()-interval 14 day\") as bench"); $server1=mysql_fetch_object($status1); $message="Hi...\n The time is: $server1->time\n connection id for this request: $server1->connection\n server version: $server1->version\n records found: $total\n records deleted: $delete\n The above stats were based on the following query:\n \"delete from prayer where Posted <= now() -interval 14 day\"\n The script that generated this message took $server1->bench seconds to process\n This mnessage is automatically generated.. don't reply to it.\n"; mail("aborka@wellstonmichigan.com", "Franklin nightly report", $message, "From: system@franklin.org"); ?> server admin has: **000000 wget --spider http://www.franklinmin.org/prayer/maint.php in the crontab (or something like it) for some reason when i run the script on my server it works fine no problems at all(apache 1.3.xx, php 4.3.2 src1, mysql server 3.2.3.xx on win ME) it works fine with that setup but for the wierd reason it doesnt work on the server runs (apache 1.3.xx, php 4.02, mysql 3.2.2.1 and linux 8.3) any ideas why it would work on 1 and not the other?

« previous php.general (#145586) next »