I have three tables, student, carry and carry mark table.
Below is the carry mark table.
+----------+---------+-------+
| stu_name | ca_name | mark |
+----------+---------+-------+
| A | Quiz1 | 9.50 |
| B | Quiz1 | 7.00 |
| A | Quiz2 | 10.00 |
| B | Quiz2 | 10.00 |
| A | Quiz3 | 9.80 |
| B | Quiz3 | 7.80 |
| A | Quiz4 | 5.00 |
| B | Quiz4 | 5.90 |
| A | Quiz5 | 10.00 |
| B | Quiz5 | 10.00 |
+----------+---------+-------+
I would like to know, is it to possible to display the data in the horizontal way in php and sql??
Stu_name Quiz1 Quiz2
A 9.5 10
B 7.0 10
Thank you.
