Order by top rated?

Sled · 11-10-2007, 01:13 PM

Hey,
I've installed this ajax rating script on my site, and I'd like to have a list with 5 items, ordered by top rated.
Thins are stored like this in database: there's a column with the total votes, and a column with total value. (this is to make sure every vote has same importance)
Now to order them I'd need to do something like order by totalvalue/totalvotes.
But I have no idea how to do that ...
Any suggestions please?

Thanks!

CMellor · 11-10-2007, 04:58 PM

Hey, I'm pretty sure I know what AJAX rating bar your talking about, I used the base of it's code to make my own. This answer isn't 100% going to be what you want, but I like to attempt to help :) Try:

PHP Code:


			
ORDER BY ( totalvalue / totalvotes ) DESC // or ASC, whatever

bluesaga · 11-13-2007, 09:58 AM

Quote:

Originally Posted by CMellor

Hey, I'm pretty sure I know what AJAX rating bar your talking about, I used the base of it's code to make my own. This answer isn't 100% going to be what you want, but I like to attempt to help :) Try:

PHP Code:


			
ORDER BY ( totalvalue / totalvotes ) DESC // or ASC, whatever

That isnt a neat way of doing it, the following would be better:

PHP Code:


			
SELECT (totalvalue / totalvotes) as valbyvotes FROM table ORDER BY valbyvotes DESC

Sled · 11-13-2007, 08:12 PM

Thanks guys, I didn't know you could use "/" in queries.
I should be able to get further now :)