Re: cron job
| From: | Joshua Hoover | Date: | Mon, 18 Feb 2002 16:36:22 +0000 |
| Subject: | Re: cron job | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-17038@lists.php.net to get a copy of this message | ||
Hi Jen,
Remove the "WHERE" clause (in your code: WHERE uid={$session["uid"]}) in
your query and that will update all rows in the table.
Hope that helps,
Joshua Hoover
> Ok I have the cron job figured out. The only thing I would like help with is
> how to update all users in a table.
>
> This just updates a spacific user:
> $db["points"]=("UPDATE wt_users set points = points + 1000 WHERE
> uid={$session["uid"]}");
> $result=mysql_query($db["points"]);
>
> How would I use this to update all users.
>
> Any help would be appreciated.
>
> Thanks
> Jen
>
>