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