Displaying Average

[eluser]Dam1an[/eluser]
There's a handy second paramter (it's in the user guide)

Writes a "SELECT AVG(field)" portion for your query. As with select_max(), You can optionally include a second parameter to rename the resulting field.