Can you update a MySQL value within the query?

[joecooper]

I have a value that in parts of my code i need to update. Its a number value, stored as TEXT. which i need to add numbers to it, at the moment I am using this to get the current value:

 

      $sql2="SELECT * FROM weekly LIMIT 1";
      $result2=mysql_query($sql2);
      $row2 = mysql_fetch_array( $result2 );
      $rollingjackpot = $row2['rollingjackpot'];

 

then i am adding the value to the varible, then using UPDATE to update it again, cant this be done in a simple query?

 

something like:

 

$query = mysql_query("UPDATE weekly SET `rollingjackpot` + $amount WHERE `id` = '1'") or die(mysql_error());

[MarPlo]

Hy,

I think this query is good:

"UPDATE weekly SET `rollingjackpot`=`rollingjackpot`+$amount WHERE `id` = 1"