Answer the question
In order to leave comments, you need to log in
How does the rating system work on websites?
How does the rating system work on websites? For example, on ad sites? Is there any commonly accepted logic/calculus?
I need to implement a rating system on the ad site, which will depend on positive reviews and negative ones. I would like to know what happens if the number of negative becomes much more than positive, and so on.
Answer the question
In order to leave comments, you need to log in
The usual arithmetic mean is calculated. A table with the item_id and rate fields is stored separately.
The rating is
SELECT SUM(rate) as sumrate, COUNT(item_id) as cnt from ratings where item_id=345 group by item_id
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question