Hi there, i'm trying to create a class schedule for subjects where students can view what's available and later on book a position in a class.
Here are the images of what i'm trying to achieve: https://imgur.com/a/Ie4XO
I want to retrieve the table name and ID of students that have booked a place in a class from the subject table and show them in the main table in the correct time slot.
Is there any online resouces which can help me achieve this? i have already created the tables in my database, the tables but having issues on how to progress.