decimal placing

[chambers9661]

Hi there,

I have a database with table column called EXPAMOUNT

if EXPAMOUNT value was £5.50
it only displays £5.5. when i echo it. How do i get it to display 2 decimal places. So £5.50

My code at moment

echo “Total Expenses &nbsp &pound” . $row[‘SUM(EXPAMOUNT)’]. “

[Barand]

Take your pick

SQL

SELECT FORMAT(SUM(EXPAMOUNT), 2) as exptotal

PHP

$x = 5.5;

echo sprintf("%0.2f", $x) . '<br>';      //--> 5.50

echo number_format($x, 2);               //--> 5.50

 

[chambers9661]

Thanks i will try it.