can't add database values

[ueon]

if ($addexperience) {
$getexpx = mysql_query("SELECT exp FROM profile WHERE profileid='$id'");
$getexp = mysql_fetch_row($getexpx);
$exp = $getexp['exp'];
$expreal = $exp + 50;

$insertexp = mysql_query("UPDATE work SET exp='$expreal' WHERE WorkID='$workid'");
 echo $expreal;
}

 

the 'exp' starts are 0, and only adds up to 50, but I'd like it add 50 every time this code is executed

[Pikachu2000]

You select the same value from the exp table every time and add 50 to it, thus the result is the same every time.

[ueon]

so what do I have change to make it work? :\

[Pikachu2000]

Well, it depends on what your end goal is. Is all that's necessary to add 50 to the value of `exp` in the `work` table each time the query runs or is there a specific reason you have it tied to the `exp` table as well?

[ueon]

i'm good as long it adds the value to 100, 150, 200, etc.

[Pikachu2000]

This query string will do that, as long as $workid contains the proper value.

 

UPDATE work SET exp = (exp + 50) WHERE WorkID='$workid'

[ueon]

works great

[mikosiko]

[OT] .... your nickname make me laugh... hopefully it doesn't represent you