Loop though DB adding values

[joecooper]

Hi,

 

I have a database with some rows. in each row there is a number such as: 0.0023 or 0.0135...

 

I have the following code to loop though them and add the numbers up but it always returns 0?

 

$sql="SELECT * FROM tickets WHERE `round` = '$round' AND `confirmed` = 'yes' ORDER BY id ASC";
$result=mysql_query($sql);
$row=mysql_fetch_array($result);

while($row = mysql_fetch_array( $result )) {
   $balance = $balance + $row['amount'];
}

 

 

[jcbones]

Is the amount column a float?

 

$sql="SELECT SUM(`amount`) AS total FROM tickets WHERE `round` = '$round' AND `confirmed` = 'yes' ORDER BY id ASC";
$result=mysql_query($sql);
$row=mysql_fetch_array($result);

while($row = mysql_fetch_array( $result )) {
   echo $row['total'];
}

[trq]

You should do this in your query not php. Mysql has a SUM() function.

[joecooper]

ah thats it. although i have done away with the "while" altogether. also forgot to set the feild to FLOAT.

 

Just quickly, how to format this to 8 decimal places?

[joecooper]

done it with number_format

 

Thanks!