The query below gives me the result: $56.6
<?php
$sum = mysql_query("SELECT SUM(amount) FROM table1");
while($row = mysql_fetch_array($sum5)){
$total = $row['SUM(amount)'];
}
echo $total;
?>
But, I want it to echo: $56.60
How do I ensure adding a zero when needed?
