Convert to decimal number

Question

I have a script that calculates the total values and then demonstrates the total value in an echo. The problem is that the value is demonstrated without colons or commas, ex: 82700 to: 827.00 would like to convert it to decimal number but is not working yet.

<?php // Make a MySQL Connection $con = mysql_connect('', 'flash548_passhms', 'passhms');

if (!$con) { die('Could not connect: ' . mysql_error()); }

mysql_select_db("flash548_passhms", $con);

$query = "SELECT month, SUM(overhead) FROM projections_sample GROUP BY month";
$result = mysql_query($query) or die(mysql_error());

// Print out result 
while($row = mysql_fetch_array($result)){
    echo "Despesas". $row['month']. " R$". $row['SUM(overhead)']; //overhead
    echo "<br />";
} 

?>

Answer 1

It seems that your data is stored in cents, since they return from the bank as INT (based on the description of the problem). The easiest (assuming the above) is to make the decimal number in the query:

SELECT month, ROUND(SUM(overhead)/100, 2) FROM projections_sample GROUP BY month

This will give you a decimal for PHP to display.