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? Link to comment https://forums.phpfreaks.com/topic/61404-solved-group/ 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(). Link to comment https://forums.phpfreaks.com/topic/61404-solved-group/#findComment-305611 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 Link to comment https://forums.phpfreaks.com/topic/61404-solved-group/#findComment-305639 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.