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