Division

I am working on a system that rates articles.

It has a colum called Rating, and one called Times Rated.

Rating is the total of all the ratings put together.

So if an article is rated with the scores: 4 4 1 2 4
Rating = 15

Times Rated is the number of times it has been rated, so using the example above that would be 5.

I can then work out the actual rating by doing Rating/Times Rated = 3.

If I wanted to rank articles using this, how would I do it? Can I literally do:

Code: Select all

$sql = mysql_query("SELECT * FROM content  ORDER BY rated/times_rated DESC LIMIT 0, 5");

Or is there another way?

Cheers,

Jack

__________________
Jack Franklin - Webforumz Moderator
(x)HTML | CSS | PHP | MySQL | JQuery (Javascript)
Contact: My Blog | Twitter | Delicious
Want Lessons? PM me.
If you think I've helped, please press the 'Thanks' Button.