Well, there are quite some differences difference between the results
these two pieces of code yield. Let's see what your sql query would be
for the first version, replacing $deposit in $query:
UPDATE wt_users set bank_points + $user_depositset points - $user_deposit WHERE
uid={$session[uid]}
^1 ^2 ^3
whereas we probably want
UPDATE wt_users set bank_points=bank_points + $user_deposit, points=points -
$user_deposit WHERE uid={$session[uid]}
I marked the three problems in your original code (you'll want to use a fixed
character to see them properly):
1. set who to this value?
2. There must be a space there
2bis. set and set don't go well together - we want a comma instead
3. same as 1
OTOH, you may want to get rid of those brackets in $query=(...) - they
really don't do anything...
HTH
Bogdan
Jennifer Downey wrote:
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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
