I have a table in mysql cauled subjects consiting of "id","subject1","subject2","subject3","subject4","subject5". What i want is to write some php code to search these. eg search for all students doing Maths, English and Physics only.
How do i do this?
Bad db design here - bercause Maths can appear in any of 5 fields.
Should be
student table studentid, name, address, etc
subjects table subjectid, name, teacher, etc
students-subjects studentid, subjectid
