how to make this script work...
| From: | Prince | 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?