I am using a query to calculate the average of some numbers in a table.
the problem is that when i use this: <? echo $row->average; ?>
I get numbers with decimals. Is there some way I can round the <? echo $row->average; ?> to the nearest whole number?
I also need to grab the number of rows used to calculate the average and echo it like <? echo $row->average; ?> - <? echo $row->total; ?>
IE: if Mike's Restaurant had 10 records, <? echo $row->total; ?> would say 10.
$query = "SELECT a.venuename, a.venueid, b.stars, b.reviewtext, AVG( stars ) AS average
FROM venue a, venuereview b
WHERE a.venueid = b.venueid
AND b.switch = '1'
GROUP BY b.venueid
ORDER BY average DESC";
$result = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_object($result))
<p> <strong><? echo $row->venuename; ?></strong> - <img src = "<? echo $row->average; ?>"/></p>