[SOLVED] Help with concat in query

[Darkmatter5]

Here's the query I have so far

 

SELECT g.game_id, g.title, s.name

FROM games AS g

Inner Join game_systems AS gs ON gs.game_id = g.game_id

Inner Join systems AS s ON s.system_id = gs.system_id

WHERE g.admin_approved =  '0'

ORDER BY g.title ASC, gs.game_id ASC, s.name ASC

 

Here's the current result

game.id title                      systems

49        Bionic Commando PC

49        Bionic Commando Playstation 3

49        Bionic Commando Xbox 360

51        Bionic Commando Wii

52        Bionic Commando Nintendo DS

 

I'm wanting to list each title grouped together, but concat the systems together to something like this.

game.id title                      systems

49        Bionic Commando      PC, Playstation 3, Xbox 360

 

How can I do that?

[Ken2k7]

GROUP_CONCAT(s.name) and add a GROUP BY game.id

[Darkmatter5]

Thanks!