Select records from a table using checkbox
I have a weird requirement on a PHP app.
I have a table that is showing students that have taken a course in the past. The tables are setup like this
table 1: SCHEDULED COURSES
table 2: COURSE REGISTRATIONS (shows students that have registered for scheduled courses)
table 3: STUDENTS
The table right now shows students that took a specific scheduled course. All students get listed.
I need to tick each student that the instructor needs to print a card for (may or may not be all students) and then run a query to select only those students and export those to an excel spreadsheet.
Obviously its not as easy as doing a SELECT STUDENT ID because it needs to pull information specific to each course. I guess a LEFT JOIN would work but how to I work tick boxes into a query on the following page?