jaymc Posted July 23, 2007 Share Posted July 23, 2007 Here is my table What I want to do is query it and produce a row in HTML for each user with what they have been rated by another member So, the output I want to achieve would be someling like this Ian | JMC | Meetable | Kissable | Dateable danass | JMC | Meetable | Kissable | Shagable | Sound | Sexy I cant get my head round how to jam this into one query taking advantage of GROUP Any Help? Quote Link to comment Share on other sites More sharing options...
Wildbug Posted July 23, 2007 Share Posted July 23, 2007 Look up aggregate group functions in the MySQL manual, particularly GROUP_CONCAT(). Quote Link to comment Share on other sites More sharing options...
jaymc Posted July 23, 2007 Author Share Posted July 23, 2007 Cheers it appears to be doing what I want Thanks 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.