[SOLVED] Adding into a DB?

[thewhat]

I've got a form and a script that updates a number of columns in my DB upon activation. I'm now trying to add a section that adds into a certain column. For instance, say the column has the number 15. The piece of code should add 5 more, updating it to 20. How would I do this?

[GingerRobot]

Well, the query would be something like:

 

UPDATE tbl SET col = col +5

 

Im not entirely sure if that's what you were asking though.

[thewhat]

$addition = ($userdata['user_AvailableTurns'] + 5);

 

$result = dbquery("UPDATE ".$db_prefix."users SET user_LastManagement= '$now',  user_AvailableTurns = '$addition' WHERE user_id='".$userdata['user_id']."'") or die(mysql_error());

 

This worked. Thank you.