PHP / Mysql / Html Table - Group by row

Question

I have a mysql table that has 3 columns: sid, cid and data. The table looks like below:

|sid   ||cid     ||data            ||
|62    ||name    ||John            ||
|62    ||age     ||20              ||
|62    ||email   ||[email protected]   ||
|63    ||name    ||jane            ||
|63    ||age     ||30              ||
|63    ||email   ||[email protected]   ||

What I would like to do is, using php, have an html formatted as:

|sid   ||name    ||age || email          ||
|62    ||John    ||20  || [email protected]  ||
|63    ||jane    ||30  || [email protected]  ||

Is this possible?

UkFLSUI · Accepted Answer · 2018-04-15 02:55:45Z

1

Yes, obviously it is possible. You can join the same table thrice with itself and get the output from that. May be this is what you want:

SELECT a.sid AS sid, b.data AS name, c.data AS age, d.data AS email
FROM 
test a inner join test b on b.sid = a.sid
inner join test c on c.sid = a.sid
inner join test d on d.sid = a.sid
WHERE b.cid = 'name'
AND c.cid = 'age'
AND d.cid = 'email'
GROUP BY a.sid;

And here's the sql fiddle: http://sqlfiddle.com/#!9/1714b/37

answered Apr 15, 2018 at 2:55

UkFLSUI

5,6906 gold badges38 silver badges50 bronze badges

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

Collectives™ on Stack Overflow

PHP / Mysql / Html Table - Group by row

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related