[Resolved] rating system

tuf-web_co_uk

hey

i have a script which loads 2 fields from a table

rating - the total sum of all the votes for that tip
votes - the total number of votes for that tip

when the script loads it takes rating and divides it by votes

eg (rating - 10, votes - 2)

$rating = $row[rating] /  $row[votes];
echo $rating;

the outcome should be 5

using this method i have trouble ordering the results depending on their rating

i dont think it is possible to have a select statement which would be something like

select * from tips order by rating / votes desc

or is this possible?

can someone help me to order these in this way, or link me to a script which works like this?

thanks Comms 😉

jayant

select * from tips order by (rating/votes) desc

select *, (rating/votes) AS ratings from tips order by ratings desc

one of these should work.

tuf-web_co_uk

thank you very much

that worked great 😃

jayant

Marking the thread as 'resolved' is more important than saying "thanks. that solved it"

tuf-web_co_uk

sorry

Bijan

The thread is resolved and I don't wana bother too much, but it's something that I'm not getting in here!

You have 2 fields, one rating and one votes, right? Let's see if I got what they really do. For example you have tip A that 2 ppl rated, so, your rating number is 2, right? And then let's say the first person put 3 stars for your tip, and the 2nd person put 5 starts for it, so, your votes field is gonna be (5+3)/2 = 4, right?

If I'm right, then you don't even need to use that rating field, because you can change it with:

SELECT count(votes) as num_of_votes, (num_of_votes/votes) as ratings FROM tips ORDER BY ratings DESC

Note: I renamed "rating" to "num_of_votes", it's more beautiful.

Lemme know if I was right!

jayant

For example you have tip A that 2 ppl rated, so, your rating number is 2, right? And then let's say the first person put 3 stars for your tip, and the 2nd person put 5 starts for it, so, your votes field is gonna be (5+3)/2 = 4, right?

if two people rated then votes is 2, not the rating.
if first person rated 5, and other rated 3, then rating is 8.

so we simple do rating/votes.