mysql_fetch_object and AVG from SELECT problem

[ncardoso]

Hi,

I'm fairly new to this whole PHP and MYSql thing. I've run into a problem and can't seem to find any reference that explains this well.

I have created a SELECT statement that picks up values from one field from a table where field = a value.

I then get my result set. I have added AVG(field) to my select statement because I need to calculate the average value of all the values in that field.

I then get the row value using: mysql_fetch_object

My problem: I have know idea how to get that average value in order to display it using the $row-> and echo syntax.

Can someone please give my a real live example of how this really works? I didn't try the easy road.... I have been battling with this for a couple of days. Hence why I've resorted to you folks.

Thanks a million
Nelson Cardoso
[e-mail]

[volleytotal_ch]

you can only use the "avg()"-function if you have a "group by" command. Let's give you an example:

table "games"
[id] [user] [points]
1 1 8
2 1 16
3 1 12
4 2 6
5 2 10
6 3 8
...

then you can use the following sql-command:

SELECT user, AVG(points) as avg_points GROUP BY user;

the result of this example will be:

[user] [avg_points]
1 12
2 8
3 8

hope this helps 😉

[ncardoso]

Hi,

Yup.... what you told me will help me about but I'm still missing one step:

How do I get that out of the sql statement using the echo and $row info I have with mysql_fetch_object?

In your example, would I use the following?

$row->avg_points;

Do I have to loop in order to get each result?

Am I pushing my luck with your generosity??? 🙂

Another example would be great. THANKS A MILLION!!!!

Regards
Nelson Cardoso