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? Quote Link to comment 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. Quote Link to comment 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.