Easy question - Logic help.
Posted 04 September 2006 - 06:19 AM
Here's what i'm trying to do. I have a Rating system (0-5 stars). I want to display the 'Top Rated Layouts' when I 'ORDER BY ranking' it works but it displays the first layouts that have been rated with 1 vote / 5 stars.. So, what I need it to do is display the actual TOP rated layouts for example.. If a layout has 3 votes, and its average ranking is still 5 stars, obviously it's better than the layout that has only 1 vote with 5 stars. I have tried 'ORDER BY (ranking*votes)' but that bumps say a layout with a average ranking of 4.80, with 3 votes to the second position above a layout that has like 2 votes with a 5.00 ranking average.
What am I doing wrong in my logic (I suck at math.)? What do I order by? Thanks for your time.
Posted 04 September 2006 - 06:28 AM
Donations gratefully received
|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts
Posted 04 September 2006 - 06:35 AM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users