PHP MYSQLi display results

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Focasm
Forum Newbie
Posts: 1
Joined: Fri Nov 04, 2016 10:22 am

PHP MYSQLi display results

Post 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
Attachments
Image for desired results.
Image for desired results.
User avatar
Celauran
Moderator
Posts: 6427
Joined: Tue Nov 09, 2010 2:39 pm
Location: Montreal, Canada

Re: PHP MYSQLi display results

Post by Celauran »

What have you done so far and where are you getting stuck?
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Re: PHP MYSQLi display results

Post by Christopher »

Please show us the SQL for the query.
(#10850)
Post Reply