formatting output of query

[Anon]

$result6 = mysql_query("SELECT AVG(rating) FROM Rreview WHERE model='$model'",$db);
$query = mysql_query($result6,$db);
$row = mysql_fetch_array($result6);
$average = $row["AVG(rating)"];

the above code returns the average of the 'rating' field in the format 0.0000 (four decimal places).

How can I format the output ($average) so that it is of the form 0.00 (only two decimal places)?

TIA,

/frank

[Anon]

$string = sprintf ("%01.2f", $number);

[Anon]

thanks again Shaun!! That worked, though I am not sure why, but can look that up myself now that I have a function.

thanks,
/frank

[Anon]

Yeh, sprintf() has a really weird syntax for it's format strings, they take a while to get used to, hell I've been using the C version of this function for over 5 years and I still can't remember most of it <G>