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

Reply via email to