Division

Jack Franklin

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

__________________