[RESOLVED] UPDATE help please!

[dr_overload]

I run this script in php page, and I want to update the value of current_score with value pts_groupa + value of pts_groupb, but after I run the script the value of current_score is +

Can anyone show me where I have gone wrong, thanks

mysql_query("UPDATE table1 SET current_score = '$pts_groupa + $pts_groupb'");

[matt72]

try

mysql_query("UPDATE table1 SET current_score = '" . ($pts_groupa + $pts_groupb) . "'");

[Crowly]

Heres another way:

$query=sprintf("UPDATE table1 SET current_score = %d",$pts_groupa+$pts_groupb);
mysql_query($query);

%d will be replaced with the sum/result of $pts_groupa+$pts_groupb, ex if $pts_groupa = 1 and $pts_groupb = 2 then $query == "UPDATE table1 SET current_score = 3"

[dr_overload]

I tried both codes but unforunately both are giving back values of zero. Any suggestions?

[matt72]

If the query ends up as:

"UPDATE table1 SET current_score = '0'"

Then the two variables add up to zero, or they aren't set properly. Are you sure $pts_groupa & $pts_groupb are set as variables?

[Crowly]

You could try this for debugging:

echo $pts_groupa."<br>";
echo $pts_groupb."<br>";
$query=sprintf("UPDATE table1 SET current_score = %d",$pts_groupa+$pts_groupb); 
echo $query;
mysql_query($query);

It might also be useful to see your script, just remember to do this when you post (remove the *):

[php]
your script here
[/php]

[dr_overload]

Thanks everyone, that works now

Cheers