Using avg() to get column averages, from PHP????

Hello All,

I'm trying to execute this simple mysql statement from PHP but I can't get it to work:

mysql> select score from sp_t_results_World_Capitals;
+-------+
| score |
+-------+
| 100 |
| 60 |
| 100 |
+-------+

....so what I try in my php script is:

$query2 = "SELECT score from sp_t_results_World_Capitals";

$result2 = mysql_query($query2);

echo "The average score was: $result2 .";

But what I get on screen is:

The average score was: Resource id #4 .

Anybody has experience with this? Any thoughts?

have a look at mysql_fetch_array() or mysql_fetch_row()

(one of) these functions have to be performed (always)

Hello there...

I tried mysql_fetch_rows and got this:

The average score was: Array . as a result...here is the code snippet:

<?php
$query2 = "SELECT avg(score) from sp_t_results_World_Capitals";

$result2 = mysql_query($query2);
$row2 = mysql_fetch_row($result2);

echo "The average score was: $row2 .";
?>

So then I tried mysql_fetch_array....

<?php
$query2 = "SELECT avg(score) from sp_t_results_World_Capitals";

$result2 = mysql_query($query2);
$row2 = mysql_fetch_array($result2);

echo "The average score was: $row1[1] .";
?>

The result was a blank.

So now, two things....
#1 Since i'm kind-a-new I am not sure if I'm calling the variable properly in this last line.

#2 Why would array be what I get back? I was expecting a single value?

Any thoughts....?????

array, because mostly multiple fields are returned
best would be

$query2 = "SELECT avg(score) AS myavg from sp_t_results_World_Capitals";
...
echo "The average score was: " . $row2['myavg'] . ".";

or the other one:

echo "The average score was: " . $row2[0] . ".";

arrays are sometimes numeric (value in brackets is 0,1,2,...
or associative (fieldnames are ['field1'] ...)

Hey ir4z0r, it worked! Thanks a lot dude!