How do I access the result of this query?

[moon 111]

My query is this:

 

SELECT AVG(rating) FROM rating WHERE sid = '34' LIMIT 1

 

And my code:

 

<?php

$q = "SELECT AVG(rating) FROM rating WHERE sid = '34' LIMIT 1";
$r = mysql_query($q);
$rating = mysql_fetch_array($r);
$rating = $rating['AVG(rating)']; // How can I do this correctly?

?>

 

How do I access the result?

Thanks

[awpti]

$q = "SELECT AVG(rating) AS rating FROM rating WHERE sid = '34' LIMIT 1"

 

$r = mysql_query($q);

$rating = mysql_fetch_array($r);

echo $rating['rating']; // How can I do this correctly?

[moon 111]

Thanks!