bound555 09:26:16 | 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] |
smo1234 09-26-2016 | 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 ? |