trim an average 2 decimal places?

Anon

I have some code for getting voting averages that works great:

$SQL4 = "SELECT AVG(value) AS avgRating FROM ratings_temp WHERE item = \"$id\"";
$result4 = mysql_db_query($db3,"$SQL4",$cid3);
print "Rating: " . mysql_result($result4,0) . " ";

The result is something like "Rating: 4.3750". Can someone tell me how to trim the number to 2 decimal places, like 4.37?

yanyan

Good Day John,

just use the number_format() function,..
how? like this..

$SQL4 = "SELECT AVG(value) AS avgRating FROM ratings_temp WHERE item = \"$id\"";
$result4 = mysql_db_query $db3,"$SQL4",$cid3);
print "Rating: " . number_format(mysql_result($result4,0),2) . " ";

That should work..

God luck..

Kind Regards,
Brian

znouza

use printf() function

<?
printf("Rating: %0.2f ",mysql_result($result4,0));
?>

mithril

The round() method will give you more accuracy than either number_format() or printf().

http://www.php.net/manual/en/function.round.php

geoff

yanyan

either way people, it has the same result, and one thing number_format() function is not only for decimal places it can be use for results that does'nt need decimal places, but wants to see to it that it was formatted like a number.. e.g. 1,000, 124,444,444 like that.

kabish..
Brian

Anon

Thanks to all, works great!