MySql question...

[keepAway]

How can i do the sum of two numbers inside of a mysql quory, or if this is possible?

while($rand = mysql_fetch_array($cerereSQL))
   {
   $pctsteaua = $rand['puncte']; 
   echo "<pre>";
   print_r ($rand);
   echo "</pre>";
   }   

 

First i have this variable $pctsteaua who will return me a number.

This number i need to use it here.

 

mysql_query ("UPDATE liga1 SET puncte='$pctsteua + 3', m='1', v='1' WHERE echipa='Steaua' ");

 

The problem is, how i do the math inside this myslq quory to work properly and update my database not with a submited number, but with the sum between the $pctsteaua variable + 3.

[socratesone]

I haven't tried this, but I suggest you do:

mysql_query ("UPDATE liga1 SET puncte=($pctsteua + 3), m='1', v='1' WHERE echipa='Steaua' ");

 

note - don't need quotes if puncte is an int, and mathematical expressions should be enclosed in parenthesis.

[gizmola]

Put a php block around the expression you want to evaluate.

 

mysql_query ("UPDATE liga1 SET puncte='{$pctsteua + 3}', m='1', v='1' WHERE echipa='Steaua' ");

[keepAway]

Thanks for the answers, i eventually realized how to do it after lots of attempts.

 

mysql_query ("UPDATE liga1 SET puncte='$pctsteaua'+'3', m='$msteaua'+'1', v='$vsteaua'+'1' WHERE echipa='Steaua' ");