Updating Database at a specified time
| From: | Jennifer Downey | Date: | Mon, 18 Feb 2002 05:01:20 +0000 |
| Subject: | Updating Database at a specified time | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-17012@lists.php.net to get a copy of this message | ||
Would someone please help? I have looked everywhere and can not find how to
update a database at a certain time.
I am trying to get this to update at midnight instead of every time the
browser refreshes. My hosting service has cron jobs
but I don't understand how to set them up. Is there a way to set this code
up to do what I need?
<?php
global $session;
$db["points"]=("UPDATE wt_users set points = points + 1000 WHERE
uid={$session["uid"]}");
$result=mysql_query($db["points"]);
$query="SELECT points FROM wt_users WHERE uid={$session["uid"]}";
$ret = mysql_query($query);
while(list($points)=
mysql_fetch_row($ret))
print("SP: $points");
?>
Thanks in advance!
Jennifer Downey