unable to update table

[sridharao]

Hello,

$getsum1 = @mysql_query('select sum(product) as summ from tempo');  // calculating sum of values in a column named product
$row = mysql_fetch_array($getsum1);   // fetching the result into an array
$sumtot = $row['summ'];  // the result, which is number in decimals is returned as a string e. 

I need this value for additional mathematical operation, but $sumtot is storing the value as string, hence I have to convert it into double.
Instead of

$sumtot = $row['summ']; 

I use

$sumtot = doubleval($row['summ']);
echo (var_dump($sumtot)); // confirms that $sumtot holds a double value 

$finq = @mysql_query('update tempo set percent = (product*100)/$sumtot'); // using the sumtot to calculate percentage and update the same 

This query is failing, the fields are not getting updated, what is wrong?

[solitario]

Unless I'm mistaken, SELECT SUM() will not return an array.

How about:

$getsum1=mysql_query('select sum(product) as summ from tempo');

$sumtot=mysql_result($getsum1,0);

$finq=mysql_query('update tempo set percent=(product*100)/'.$sumtot);

[sridharao]

That did it! wonderful, thank you.

Actually, i was getting the result [of sum(product)] in array and checked for its presence too, but using mysql_result was the best option (as u suggested).

i making a big mistake in my sql statement, see the difference
your correct way:

$finq=mysql_query('update tempo set percent=(product*100)/'.$sumtot); 

my incorrect way:

$finq=mysql_query('update tempo set percent=(product*100)/$sumtot'); 

That made a lot of difference. i should have kept $sumtot out of single quote.
Thanks