Page 1 of 1

PHP MYSQLi display results

Posted: Mon Nov 07, 2016 11:40 pm
by Focasm
Hello, Please can you assist me on this, I have four tables in my database. 1. student table, 2. enrollment table, 3. subject table, 4. level table. The relationship between student and subject is many to many so I normalize using enrollment that took primary key from student and subject during registration process also consist Grade respectively to the points in each subject student registered on. The problem is about Displaying results in form of follows for all students. For individual it works but by grouping all students it is a challenge to me. Help Me please

Re: PHP MYSQLi display results

Posted: Tue Nov 08, 2016 7:12 am
by Celauran
What have you done so far and where are you getting stuck?

Re: PHP MYSQLi display results

Posted: Tue Nov 08, 2016 9:33 am
by Christopher
Please show us the SQL for the query.