ORDER By (dividing two columns)

[chelnov63]

Im making a gallery which allows users to rate the images. I have two columns noOfRatings (which hold the no of tiems an image has been rated) and totalRatingScore (which holds the total of all the ratings for that particular image)

 

I want to make a sort option e.g 'sort by highest rated'

 

Is there a quick way to return the recordset ORDERED by highest rated.. i wa thinking somethign along the lines of

 

SELECT * FROM TABLE ORDER BY noOfRatings/totalRatingScore

 

Can i do it this way or is some special techinque needed? cheers

[trq]

Not tested, but you get the idea.

 

SELECT noOfRatings/totalRatingScore as rate FROM tbl ORDER BY rate

[chelnov63]

Thanks for your help Thorpe..it worked pefectly