avg() function

OwenTheSamoan

I want to use the avg() function. I have a column named "blue". In this column are various numbers of 1-9. I want to get the average number for a particular group.

I'm using the code below but it doesn't work. Can someone show me what I am doing wrong? Thanks

$result = mysql_query("SELECT avg(blue) FROM table_name WHERE user_id='$user_id'") or die (mysql_error());
while ($row = mysql_fetch_array($result)) {
$blue= $row["blue"];

}

echo "$blue";

rachel2004

Use the following:

$blue = $row['avg(blue)'];

instead of:

$blue = $row['blue'];

OwenTheSamoan

thanks that worked. but there is one problem now. Let's say the average number or should I say result should equal "3". The result is coming up with "4". It seems to be adding one to the result. Any reason why this could be happening?

rachel2004

avg() gives you the mean average.

OwenTheSamoan

I'm testing it and even when I have just one entry in the column, let's say the numeral three, the result still comes up as "4". Thanks for getting back to me again.

spighita

Try

 $result = mysql_query("SELECT avg(blue) as blue FROM table_name WHERE user_id='$user_id'") or die (mysql_error());
while ($row = mysql_fetch_array($result)) {
$blue= $row["blue"];

}

echo "$blue";