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. Link to comment https://forums.phpfreaks.com/topic/68584-solved-retrieving-top-rated-items/ Share on other sites More sharing options...
fenway Posted September 9, 2007 Share Posted September 9, 2007 How are these "ranked"? Link to comment https://forums.phpfreaks.com/topic/68584-solved-retrieving-top-rated-items/#findComment-344755 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. Link to comment https://forums.phpfreaks.com/topic/68584-solved-retrieving-top-rated-items/#findComment-344763 Share on other sites More sharing options...
fenway Posted September 9, 2007 Share Posted September 9, 2007 And the table structure? Link to comment https://forums.phpfreaks.com/topic/68584-solved-retrieving-top-rated-items/#findComment-345011 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 Link to comment https://forums.phpfreaks.com/topic/68584-solved-retrieving-top-rated-items/#findComment-345954 Share on other sites More sharing options...
fenway Posted September 11, 2007 Share Posted September 11, 2007 ORDER BY rating DESC LIMIT 5. Link to comment https://forums.phpfreaks.com/topic/68584-solved-retrieving-top-rated-items/#findComment-346211 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! Link to comment https://forums.phpfreaks.com/topic/68584-solved-retrieving-top-rated-items/#findComment-346301 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.