avg() problem

[webmasternovis]

Hi all,

I'm trying to use avg, but it isn't working.

$totalaverage = mysql_query("SELECT avg(totalrating) FROM table");
$anotherrow = mysql_fetch_assoc($totalaverage);
echo $anotherrow['totalrating'];

When I try echoing it though, nothing happens. Nothing is displayed.

Please could someone give me some advice?

Thanks,
Mike

[devinemke]

obvious question: are you connected to the database?
use [man]mysql_error[/man] to see what's going on.

[webmasternovis]

Thanks for your response 🙂

Yup, I'm connected to the database.

I ran mysql_error() but nothing was echoed.

Could anyone help?

Thanks,
Mike

[peter2008]

Ok, 2 ways minimum to do it.

1 - Static way (your way):
$totalaverage = mysql_query("SELECT avg(totalrating) FROM table");
$anotherrow = mysql_result($totalaverage,0);
echo $anotherrow;

2 - Dynamic way:

$column = "totalrating";
$totalaverage = mysql_query("SELECT avg($column) FROM table");
$anotherrow[$column] = mysql_result($totalaverage,0);
echo $anotherrow[$column];

---- OR if you like -----

echo $anotherrow['totalrating'];

Hope it helps.

[webmasternovis]

Yup that now works. Thanks mate 🙂

[peter2008]

Ok mate, have a nice programming day.

Peter