This application I wrote a long time ago in PHP and MySQL that uses join sql queries to connect several tables to extract the needed information from several tables I called this program Subject Information System in PHP and MySQL. Feel free to use my code in your programming assignments and projects.
If you have some questions please send me an email at jake.r.pomperada@gmail.com and jakerpomperada@yahoo.com.
My mobile number here in the Philippines is 09173084360.
Sample Program Output