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) 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 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. 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
Archived
This topic is now archived and is closed to further replies.