I have a simple search working which searches the database by one variable from a form on an html page, the form inputs a variable name and the query statement selects where that field equals the variable. But I'm trying to figure out how to use a form with multiple checkboxes and one text box where the viewer of the page can check or fill out ANY OR ALL of the form. I'm stumped as to how to code the query where I don't know ahead which criteria the viewer will choose to search by. I have the form written but would really appreciate any help with the other part.
Please help out a newbie who never heard of php or sql 2 weeks ago!