Calcular promedio de columna

[Alexis88]

Iniciado por matt_1985

Código PHP:

$result = mysql_query("SELECT rafaga, SUM(rafaga) FROM user ") or die('You need enter a catagory ');
 

No olvides añadir un alias.

Código PHP:

$result = mysql_query("SELECT rafaga, SUM(rafaga) as suma FROM user ") or die('You need enter a catagory ');
 
if (mysql_num_rows($result)){
    $row = mysql_fetch_array($result);
    echo $row['suma']; //Imprime la suma
}
 

Saludos