Combine multiple mysql data into one string and shown with php

Question

I have a table (img1) in mysql, and want to show the data at a php page which Col2 data will be combined if Col1 is same value (like the format of img2).
Question:
To handle the combining process, do it in sql query or in php is better? And how can I do so? Thank you.

Daniel E. · Accepted Answer · 2017-11-21 09:26:05Z

1

Something like that:

SELECT COl1, GROUP_CONCAT(COL2, SEPARATOR ' ') as COL2 FROM Table GROUP BY COl1

answered Nov 21, 2017 at 9:26

Daniel E.

2,4811 gold badge16 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Nims Patel · Accepted Answer · 2017-11-21 09:29:37Z

0

select id, group_concat(`Col1` separator ',') as `ColumnName`
from
(
  select id, concat(`Col1`, ':',
  group_concat(`Col2` separator ',')) as `Col1`
  from mytbl
  group by id, `Col1`
) tbl
group by id;

You can see it implemented here : Sql Fiddle Demo. Exactly what you need.

answered Nov 21, 2017 at 9:29

Nims Patel

1,0569 silver badges19 bronze badges

Collectives™ on Stack Overflow

Combine multiple mysql data into one string and shown with php

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related