Hello i have a problem with a Sql script
SELECT col1_id, col1_name, col2 FROM table GROUP BY ?????
col1_id col1_name col2
A john bear
A john dog
A john cat
A john bear
A john dog
A john cat
A john dog
A john cat
A john bear
A john dog
A john cat
A john bear
A john dog
A john cat
A john dog
A john cat
I want to return all results. It has to return like this: echo col1_id . col1_name (A john) and then col2 (bear,dog, cat)