[SOLVED] MySQL add to existing column?

[Perad]

What I want to do is simply add an amount to the ucp_game_credits column. I do not want to call out what it is first.

 

i.e. ucp_game_credits += $newammount

 

How can I do this in SQL?

 

$sql = "UPDATE ucp_users SET ucp_game_credits='???' WHERE ucp_id='". $_SESSION['uid']."'";

[pocobueno1388]

$sql = "UPDATE ucp_users SET ucp_game_credits=ucp_game_credits+$newamount WHERE ucp_id='". $_SESSION['uid']."'";