mattyvx Posted January 4, 2010 Share Posted January 4, 2010 Hi, I have a member list stored in a database and each member must enter their city when joining. What i want to do is print a list of the top 5 cities that my members are from. The field the cities are stored in is aptly named "City". Any ideas would be appreciated! Link to comment https://forums.phpfreaks.com/topic/187138-most-popular-group-by/ Share on other sites More sharing options...
Psycho Posted January 4, 2010 Share Posted January 4, 2010 This will give you a result set of the top 5 cities and the number of users associated with each SELECT city, COUNT(city) as count FROM users GROUP BY city ORDER by count DESC LIMIT 0, 5 Link to comment https://forums.phpfreaks.com/topic/187138-most-popular-group-by/#findComment-988241 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.