Posted by Mark & Ingrid Nugent on 10/13/19 11:17

One table of my database could contain multiple values eg student_courses,
each student could have done many different courses.

For a search engine, I want to be able to tick a checkbox and get all the
students who have done that course. However, if I tick two or more
checkboxes I want to get only the students that have done all the selected
courses, not the students that have done just any of the selected courses.

I think that means I will have to run a query "SELECT student_id FROM
student_courses WHERE course_id = $id OR course_id = $id etc etc , and
filter the results with PHP.
Has anyone got a neat solution? Is there any way that MySQL could refine the
query results?

Mark

[Back to original message]