html - One ID with many values -

html - One ID with many values -

this table in database.

+-------+------------+ | id | values | +-------+------------+ | 1 | mon | | 1 | tues | | 1 | wed | | 2 | mon | | 2 | tues | | 2 | wed | | 3 | mon | | 3 | tues | | 3 | wed | +-------+------------+

and want table in client-server.

+-------+------------+ | id | days | +-------+------------+ | 1 |mon tues wed| | 2 |mon tues wed| | 3 |mon tues wed| +-------+------------+

guys idea? sql query code?

not clear how you'll using this, concat days grouped id.

// info select id, group_concat( days order id separator ' ') days table

will produce results mentioned, i'm not sure how real-world useful is.

html database