Instest of add, subtract.
| From: | Jennifer Downey | Date: | Sat, 23 Feb 2002 18:26:27 +0000 |
| Subject: | Instest of add, subtract. | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-17225@lists.php.net to get a copy of this message | ||
Hi,
Instead of helping with my other question maybe you can tell me why this
wont work?
Is it not valid ? Can you not use strings in a query like this?
$deposit="set bank_points + $user_deposit";
$deposit .="set points - $user_deposit";
$query = ("UPDATE wt_users $deposit WHERE uid={$session["uid"]}" );
$result=mysql_query("$query");
if set like this it will update the points in the bank_points but not the
points table.
$db["bank_points"]=("UPDATE wt_users set bank_points = bank_points +
$user_deposit WHERE uid={$session["uid"]}" );
$result=mysql_query($db["bank_points"]);
Thanks in advance
Jennifer Downey