Witzbold Posted July 1, 2009 Share Posted July 1, 2009 Hello, I want to do something with PHP and MySQL and I am not sure if it is even possible or if I just have hit a wall in what I know. I have a survey page that I am setting up, and I want a page where I can see what the most popular anwser is. For example I have a field called gender, and I want to display to most popular gender, with the field income, I want to display the most popular income option...is there a way to do this? Link to comment https://forums.phpfreaks.com/topic/164424-popular-anwser/ Share on other sites More sharing options...
Maq Posted July 1, 2009 Share Posted July 1, 2009 Use MAX() to and GROUP BY to get the highest income for each gender. Link to comment https://forums.phpfreaks.com/topic/164424-popular-anwser/#findComment-867376 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.