Rounding an AVG

[Clarkeez]

Hi.

I'm got this script..

<?php
$dbuser = 'user'; 
$dbpass = 'pass'; 
$dbhost = 'host';
$realmdb = 'bc_acc'; 

mysql_connect($dbhost, $dbuser, $dbpass);
mysql_select_db($realmdb);

$query = "SELECT AVG(latency) FROM characters WHERE online = 1"; 

$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result)){
echo "Latency: <strong>".$row['AVG(latency)']."ms</strong>";
}
?>

 

Now, It's printing with 4 decimal places, I need it to round it to 0 decimal place.

Can you kindly put forward some advice?

[Adam]

Use round.

[Clarkeez]

Use round.

i've tried this also..

$query = "SELECT ROUND(AVG(latency),0) AS Average FROM characters WHERE online=1"; 

$result = mysql_query($query) or die(mysql_error());

// Print out result
while($row = mysql_fetch_array($result)){
echo "Latency: <strong>".$row['latency']."ms</strong>";
}

But the output is nothing.

[Clarkeez]

Im not really sure how to echo it properly.

[Mchl]

You assigned an alias 'Average' to the result of ROUND(), so use $row['Average'] instead of $row['latency']

[Clarkeez]

Thankyou!

I feel like an idiot xD

[Mchl]

Why? You've just learned something.... unless you didn't...

[Clarkeez]

I did learn. Thankyou.