sford999 Posted August 29, 2009 Share Posted August 29, 2009 Hi, I have a database schema such as: ID, gallery_id, Images What I would like to do is count each matching row from the "gallery_id" column and display the most popular result. eg: if the gallery_id rows are (2,5,6,2,7,9,2,5,7,2,2), then 2 would be the most popular and that is the one I want to display. Am I right in thinking along the lines of: SELECT *, COUNT(images) FROM table GROUP BY (gallery_id) Quote Link to comment https://forums.phpfreaks.com/topic/172424-query-to-display-highest-total-rows-from-column/ Share on other sites More sharing options...
suresh64633 Posted September 2, 2009 Share Posted September 2, 2009 Hi, Try this SELECT *, COUNT(images) AS CNT FROM table GROUP BY (gallery_id) ORDER BY CNT Quote Link to comment https://forums.phpfreaks.com/topic/172424-query-to-display-highest-total-rows-from-column/#findComment-910780 Share on other sites More sharing options...
fenway Posted September 7, 2009 Share Posted September 7, 2009 You can't mix * with GROUP BY. Quote Link to comment https://forums.phpfreaks.com/topic/172424-query-to-display-highest-total-rows-from-column/#findComment-914149 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.