Php mysql echo results with common column -


i new php , mysql. have following table:

name                 booking herr blabla          f915863 frau kblhdahdla      f915863 frau lksfdhdsf       f915863 frau jkhdasjkddsf    f926173 herr bjfasbjkfd      f788135 frau jkbashhfsa      f788135 

i want echo in html or create table join names of same booking 1 column names, this:

names                                            booking herr blabla, frau kblhdahdla, frau lksfdhdsf     f915863 frau jkhdasjkddsf                                f926173 herr bjfasbjkfd,frau jkbashhfsa                  f788135 

i couldnt find this, not searching right words.

try this. can specify separator in group_concat

select group_concat(name separator  ', ') my_table group booking; 

Comments