Convert to decimal number

Question

Convert to decimal number

Asked 10 years, 7 months ago

Viewed 339 times

-1

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 />";
} 

?>

3

What do you want is the same as this question? http://answall.com/questions/11301/formatteca-de-numeros-php

– Maniero

2014/04/26 at 15:16
@mustache is basically this.

– the flash

2014/04/26 at 23:05
Two tips: 1) SELECT month, SUM(overhead) AS total FROM so you can use $row['total']. 2) $row['total']/100 returns what you want (however, without formatting). To format, I recommend seeing the answer given by @bigown

– Bacco

2014/04/26 at 23:34

1 answer

Browser other questions tagged php mysql

You are not signed in. Login or sign up in order to post.

by planestepper • **101** points · Answer 1 · 2014-04-26T17:06:59+00:00

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.