$query = "SELECT AVG(colonna) AS media FROM tabella GROUP BY altracolonna";
$result = mysql_query($query, $db);
$row = mysql_fetch_array($result);

echo $row['media'];

prova a vedere se cosi funziona..