Join 3 tables and match them column by rows in mysql I have a database to manage students

1. I want to Select students that are in la certain level fom the students table
2. Select the subjects from the subjects table
3. and echo the matching results on an html table

For example

The Column Headers will be
Names ... English.... Maths
James... 10...... 15

From the above we see that James scored 10 and 15 English and maths respectively.
The Names, Subjects and Scores are related/ in a table called enrol.
which has

1. id
2. Student_id [foreign key]
3. Subject_id [foreign key]
4. Level_id [foreign key]
This can be done , by query to display result in Grid . Do you have the MySQL dump of the above table structure with some sample data ?
Please Login to post your reply or start a new topic