php two dimension array

Question

I have a sql table. the table shows studentID, Subject_Name and Marks. Hope you can understand the data.

Now I need to show it in the front end by displaying studentID vertically across the Y axis and subject_Name horizontally across the X axis. Marks should appear as the table body.

I use php as the server side language.

can you just draw the output like you want and make the question meaningful. Put the query and desire output. — Murad Hasan
– Murad Hasan, Commented May 18, 2016 at 4:24
can you show us how the current table looks? and how you want it to look? — Webeng
– Webeng, Commented May 18, 2016 at 4:55

Tim Biegeleisen · Accepted Answer · 2016-05-18 04:32:38Z

1

I believe a simply pivot query will give you the result set you want:

SELECT studentID,
    SUM(CASE WHEN Subject_Name = 'CHEMISTRY' THEN Marks ELSE 0 END) AS `CHEMISTRY`,
    SUM(CASE WHEN Subject_Name = 'BIOLOGY'   THEN Marks ELSE 0 END) AS `BIOLOGY`,
    SUM(CASE WHEN Subject_Name = 'ENGLISH'   THEN Marks ELSE 0 END) AS `ENGLISH`,
    SUM(CASE WHEN Subject_Name = 'MATH'      THEN Marks ELSE 0 END) AS `MATH`
FROM students
GROUP BY studentID

You can replace and add/subtract the sample columns I gave with the names of the actual course subjects in your table.

Follow the link below for a working demo:

SQLFiddle

edited May 18, 2016 at 4:32

answered May 18, 2016 at 4:27

Tim Biegeleisen

526k32 gold badges323 silver badges399 bronze badges

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

Collectives™ on Stack Overflow

php two dimension array

1 Answer 1

SQLFiddle

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