Output problem

[bineye]

$query=mysql_query("SELECT teamid, AVG(rating) FROM players WHERE teamid=$getteam", $c) or die(mysql_error());

$result=mysql_fetch_assoc($query);

Team Rating: ".$result." 

 

Hi, my problem is that $result returns "Array" instead of an average value of the column "rating". Any ideas why this is happening? Thanks.

Edited April 6, 2011 by bineye
add tags

[Nickson]

mysql_fetch_assoc() returns an array where each key is a field out of the database-query as you named them via your select query.

You would have to use $result['NAME_OF_FIELD']

References:

http://be2.php.net/mysql_fetch_assoc

[galdikas]

alternatively you can

extract($result);

Team rating: $name_of_column_in_db;