Gebruik van AVG

$sql = "SELECT avg(aantal) FROM `tabel`;";
$gemiddeld = mysql_query($sql) or die(mysql_error());
echo "$gemiddeld";

$sql = "SELECT avg(aantal) FROM `tabel`;";
$gemiddeld = mysql_query($sql) or die(mysql_error());
echo "$gemiddeld";

<?php
$sQuery = "SELECT AVG(`aantal`) AS `gem` FROM `tabel`";
if($rResource = @mysql_query($sQuery))
{ echo 'Gegevens verzamelen is niet gelukt.'; }
else
{ 
$aRow = mysql_fetch_assoc($rResource);
echo $aRow['gem'];
}
?>

<?php
$sQuery = "SELECT AVG(`aantal`) AS `gem` FROM `tabel`";
if($rResource = @mysql_query($sQuery))
{ echo 'Gegevens verzamelen is niet gelukt.'; }
else
{ 
$aRow = mysql_fetch_assoc($rResource);
echo $aRow['gem'];
}
?>