Jump to content


This topic is now archived and is closed to further replies.


Easy question - Logic help.

Recommended Posts

Hey guys, having some trouble with my logic CAUSE I SUCKKK.

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.

Share this post

Link to post
Share on other sites
Oh, wow didnt realize you could double order things like that... Pimp... haha glad i read this post :P

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.