Search keywords won't return results from a string

The search will return items when using keywords 'green' or 'grease' (entered separately), but not when entered together with a space between. For example, if a product description in the Db reads "green is the best grease", and "green grease" is entered as keywords, it should find that product.

I found a post with this problem, but it went private and couldn't see the solution.

File attached.

You can fix this by adjusting the "Implied AND" in the search comparison settings.

You can set it to be a space character and then it would read that as AND instead of using an exact match.

To change it in the code just find: "%20OR%20"
and replace it with: "%20"

Same results. I changed it in two places:

//comparison list additions
$WADbSearch2->keywordComparison($KeyArr1,"".("".(isset($_GET["WADbSearch2"]))?$_GET["WADbSearch2"]:"") ."","OR","Includes","%20AND%20","%20OR","%22,%20%22","%22%20%22",0);
$WADbSearch2->keywordComparison($KeyArr2,"".("".(isset($_GET["WADbSearch2"]) && is_numeric($_GET["WADbSearch2"]))?$_GET["WADbSearch2"]:"") ."","OR","=","%20AND%20","%20OR","%22","%22",1);
$WADbSearch2->addComparisonFromList("ID","itemchecked","AND","=",1);

It doesn't appear the changes were uploaded. I had FTP access, so I went ahead and made the updates.

Still not working as it should. When 'high speed' is entered, it should find products that have both high AND speed in the description (5 products), but it finds products that have combinations of high OR speed (61 products).

You just have to switch the "Implied AND" and "Implied OR" values in the UI so that the space character implies an AND instead of an OR. I've gone ahead and done that for you.

I've added a table to the Db and reconfigured the Recordset LEFT JOINs, and also the Wizard to add in the additional columns. However, when I exit the Wizard, it tells me to be sure that what's supposed to be in the AND is not in the OR, and won't let me go further.

When I switch these around, I can close the Wizard, but the search no longer works properly.

I tried pasting in the above code to get it to work again, but on opening the Wizard it now says I have a syntax error and all editing must be made through the Wizard.

The search finds the new table, but not 'green grease' which was the original issue. Since you fixed the issue, I don't know how to get back where we were without running into the Wizard error message.

That is because you are setting the implied AND to a " " space and implied OR to ", " comma space. I think if you remove the space after the OR you will be able to apply without errors. Having the implied AND inside the implied OR is ambiguous so that is why it is giving the error.

I can't edit the wizard now - error message: format of server side code is invalid. Plus I get an MM Error where the listings are.

I'm sure I edited the code wrong, but can't get back to where it was. Tried pasting in the code from the earlier post, but that doesn't change anything.

File attached.

I've updated the page so that you can edit it with the interface again and so that it works properly with the correct implied and and implied or.