Tweaking search criteria - AND/OR etc
I've got a working search page here, for a driving schools database:
search/
But I'm not sure how to quite get the search as I would ideally like.
Basically there are a number of text fields, all using AND, which is fine.
There are also two checkboxes for schools with female instructors or intensive course.
So for example, I have added two schools with a name containing Handprint.
The way I have in my head it would work is that if you just search for Handprint, and leave both checkboxes unchecked, it should find both schools called Handprint.
i.e. WHERE school contains Handprint AND Female = Y OR N AND Intensive = Y OR N
But using AND, if they're left unchecked its only finding the Handprint without them checked.
WHERE School contains Handprint AND Female =N and Intensive =N
//comparison list additions
$WADbSearch1->addComparisonFromEdit("School","S_School","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("Owner","S_Owner","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("Area","S_Area","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("Town","S_Town","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("County","S_County","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("PostCode","S_PostCode","AND","Includes",0);
$WADbSearch1->addComparisonFromCheck("Female","S_Female","N","N","AND","<>","=",0);
$WADbSearch1->addComparisonFromCheck("Intensive","S_Intensive","N","N","AND","<>","=",0);
Alternatively, if I use OR for the checkboxes, the results return and school called Handprint, or with no female instructors or intensive courses.
WHERE School contains Handprint OR Female = N OR Intensive = N
//comparison list additions
$WADbSearch1->addComparisonFromEdit("School","S_School","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("Owner","S_Owner","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("Area","S_Area","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("Town","S_Town","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("County","S_County","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("PostCode","S_PostCode","AND","Includes",0);
$WADbSearch1->addComparisonFromCheck("Female","S_Female","N","N","OR","<>","=",0);
$WADbSearch1->addComparisonFromCheck("Intensive","S_Intensive","N","N","OR","<>","=",0);
Not sure if I've explained that very well, or if its even possible?
Thanks for any pointers or suggestions.