Format number

[jacquesy]

I am using the following sql code:

SELECT round sum(model_rating) / count(model_id)
AS average where ..........etc

The output returns a figure with 2 decimanl places, ie. 96.00.

I need to change this so the figure returned is a whole number, (96) can anybody help?

Thanks.

[JDcrack]

Here are some functions that should get you on the right track:
number_format()
round()

$number = 1234.9678;

echo number_format($number, 0, '.', ',');
 // rounds number to 0 places to the right of the decimal
// optionally adds a comma for the thousands seperator
// will print 1,235

echo round($number, 0);
    // rounds number to 0 places to the right of the decimal
   // will print 1235

[jacquesy]

excellent, thanks!