Averaging MySQL fields

[Jolten]

Hi,

I'm trying to write a simple query to retrieve an average of fields in one of my tables.


$average = $DB_site->query("SELECT AVG(points) FROM usrPoints WHERE atoContId = 662");


I've tried just about everything I can think of or find as far as searching the 'net. The query simply returns a resource ID.

Can anyone help me set the query to actually return a value?

Thanks.

[Andreas]

Maybe


$average = $DB_site->query_first("SELECT AVG(points) AS avgpoints FROM " . TABLE_PREFIX . "usrPoints WHERE atoContId = 662");


and the use $average['avgpoints'] ?

[Jolten]

I don't need the table prefix for my database so I removed that.

But using $average['avgpoints'] does work! Thanks!!!

[Andreas]

I also don't need that in my database.
But it is good coding style to follow vB3 coding standards.
And it makes life easier if you ever have to switch your host(and then maybe have to use prefixes)

[Jolten]

True. :) But if I were to ever need prefixes it would be a week long undertaking to fix the other queries in my custom pages as well. :)

Thanks so much for the assist Kirby. I owe you one.