Need Help With Incrementing Values

[olygolfer]

Hi I need some advice on formating a currency value when incrementing. Explained Below:

I have set up a product to a value of £5.00 in my mysql database, if i then run a query that selects it directly and echos it to the page it appears as it should ie. £5.00

however when i want to run a query that increments alot of values to get a total it appears as a number with no decimals. ie. £5

The code i have been using is below. ANY IDEAS (its shortened to the most important areas of code)

$totalprice = 0;

while ($myrow = mysql_fetch_array($result))

{
$totalprice+= $myrow["price"]; 
}

echo "<td><p class=\"Text1\">&pound;".$totalprice."</p></td>";

[cgraz]

It's because both your decimals are .00

If $myrow["price"] was equal to say $5.23, then you'd get $5.23 outputted. To solve this, just use number_format() when you print your variable.

echo number_format($totalprice, 2);

Cgraz

[olygolfer]

Thanks YOU THE MAN