I have a search form used to locate missing persons reports matching certain criteria, and am adding a section with checkboxes to examine field "eyecolor". I am using a shorter version for this question.
The boxes on the form are:
In the database, black is stored as "1", blue as "2", and Brown as "3"
How can I write the PHP and SQL query to handle this on the backend? When I tried to write it, I can't account for how to add the "OR" between multiple selction in the SQL, or how to not list "OR" if only one item is chosed.
The added twist is - I need for "all" to somehow negate any selections and not add specification to the query.
Thanks in advance for any help or guidance you can provide,