jonathanrai
New Member
\[quote\] Possible Duplicate:
MySQL (or PHP?) group results by field data \[/quote\]Guys, I have a database (mysql) similar to this now:\[code\]ID meta_key meta_value name1 _group 1 John2 _group 1 Andrea3 _group 1 Jack4 _group 2 Mike5 _group 2 Kurt6 _group 3 Alice\[/code\]and I need to sort / display it like this:\[code\]group name----------------------- 1 John Andrea Jack----------------------- 2 Mike Kurt----------------------- 3 Alice-----------------------\[/code\]I had a similar issue before, thanks for the previus help! But now i'm stucked with this.I really appreciate your help.
MySQL (or PHP?) group results by field data \[/quote\]Guys, I have a database (mysql) similar to this now:\[code\]ID meta_key meta_value name1 _group 1 John2 _group 1 Andrea3 _group 1 Jack4 _group 2 Mike5 _group 2 Kurt6 _group 3 Alice\[/code\]and I need to sort / display it like this:\[code\]group name----------------------- 1 John Andrea Jack----------------------- 2 Mike Kurt----------------------- 3 Alice-----------------------\[/code\]I had a similar issue before, thanks for the previus help! But now i'm stucked with this.I really appreciate your help.