How to get results from a joined query

[eluser]vitoco[/eluser]
[quote author="Mike Ryan" date="1238790728"]-------

Edit: Damn, someone beat me to it :-)

-------

Hi Steve,

Looks like using GROUP_CONCAT is causing the field to be renamed.

Try changing your SQL statement to:

Code:

... a.users_username, GROUP_CONCAT(b.game_id SEPARATOR ' ' ) as game_id FROM...

You could do print_r($row) during your loop to make sure the game_id value exists. This will print out the entire array structure - very useful.[/quote]

4 minutes baby !!! ...jajjajaja , but's ok , you response it's maybe more clear .