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
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.
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 ?|