CODE EXAMPLE FOR PHP

how to get the average in sql in php

$result = mysql_query("SELECT AVG(fieldName) AS avg FROM tableName");
$row = mysql_fetch_assoc($result); echo $row['avg']