problem with UPDATE

[Inkybro]

For a game at wizardduels.com we need to use an update sql command to update their money when they win, but it doesn't do anything. The money value is left exactly the same. I hope someone can help.

//add wc script
mysql_connect('localhost','*****','*****');
mysql_select_db('wizardduels_com');
$result1 = mysql_query("select * from users where user='".$user."'");
$result2 = mysql_fetch_assoc($result1);
$currentwc = $result2['wc'];
$currentwc = $currentwc + $result;
mysql_query("update users set wc=".$currentwc." where user='".$user."'");

[sgoku01]

I'm not sure, but does it update when you do this:

mysql_query("update users set wc='".$currentwc."' where user='".$user."'"); 

I placed two ' by wc=

[Inkybro]

no... thats what i had it at before and i changed it and it still didn't work

[xblue]

make the script output the query and the mysql error (if any), in most cases this helps to narrow down what's going wrong. May be good to take a look what value $result has, too.

BTW, there is an easier way to add something to the previous DB value with only one sql statement:

update users set wc=wc+".$currentwc." where user='".$user."'