courage Posted September 9, 2007 Share Posted September 9, 2007 I am in need of a query that can select the five top-rated items in a database table. My ratings would be 1.7, 8.9 etc. However I have been unable to find a script or tutorial on the internet that describes how one could go about doing this and I have tried many weird and wonderful methods to do this with no avail. I see this done on many websites. I apologise if the answer is sitting under my nose. Quote Link to comment Share on other sites More sharing options...
fenway Posted September 9, 2007 Share Posted September 9, 2007 How are these "ranked"? Quote Link to comment Share on other sites More sharing options...
courage Posted September 9, 2007 Author Share Posted September 9, 2007 By a value stored in the "ratings" column. eg. 1.7, 8.9 etc. Quote Link to comment Share on other sites More sharing options...
fenway Posted September 9, 2007 Share Posted September 9, 2007 And the table structure? Quote Link to comment Share on other sites More sharing options...
courage Posted September 11, 2007 Author Share Posted September 11, 2007 The table is sorted into columns: id, title, genre, rating, num_rates, total_rate... Sorry if I am vague with the details, I don't have much time available since I am currently operating from an internet cafe and don't have the money to pay for another session. - Courage Quote Link to comment Share on other sites More sharing options...
fenway Posted September 11, 2007 Share Posted September 11, 2007 ORDER BY rating DESC LIMIT 5. Quote Link to comment Share on other sites More sharing options...
courage Posted September 11, 2007 Author Share Posted September 11, 2007 Thanks so much, worked like a charm! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.