Averaging a MYSQL Column

[Anon]

Hi. I'm created a web page that has a section where people review certain apartment complexes. It posts the data into a MYSQL DB. I need to figure out a way to take the entire 'rating' column of that table and average all the numbers and then store the average rating in a variable to be displayed dynamically. Is there any built in functions, either PHP or MYSQL that can do this? Or does anyone have any ideas of how I can do this. I am fairly new to all this and your help is greatly appreciated.

Thanks.

Nick Ladd

[mp96brbj]

If your ratings are stored as integers, you can do this:

SELECT AVG(rating) FROM myTable
GROUP BY apartment;

If you want a more good-looking result:

SELECT apartment, AVG(rating) AS avg_rating FROM myTable
GROUP BY apartment
ORDER BY avg_rating DESC;