When i change the second comparison to OR and search for camera it shows ALL database results.
//comparison list additions
$WADbSearch1->keywordComparison($KeyArr1,"".((isset($_POST["what"]))?$_POST["what"]:"") ."","AND","Includes",",%20","%20","%22","%22",0);
$WADbSearch1->keywordComparison($KeyArr2,"".((isset($_POST["area"]))?$_POST["area"]:"") ."","OR","=","%20AND%20","OR","%22","%22",0);
If a user was looking for a camera, they would most likely search for cameras, eg: "Digital Cameras", is there any way around this other than changing the records? Listing an item as eg: "Nikon D700 Digital Cameras" for a single camera would not be sensible.
I just did a Google search for "cameras" and both "camera" AND "cameras" came up in the results. How do they achieve this? Do they have a database column containing all keywords assosiated with the product?
Also i want it to work on EITHER or BOTH fields as some users would just search camera, other users would search for camera and the area. Is this possible?