Advanced Search - Attributes

[michael_s]

(I have tried to contact the author of this contrib directly, but I need to get an answer ASAP because where I work everything is due yesterday, so I'm also posting it here...)

I have installed Adam's advanced search by attributes function and it works well. However, the search results are different from what I expected, and I am not sure if it is my database, or the way the code is written. (I think that it is the code.)

I have two attributes: size and color. Lets say that I want to search for all products that are 2" wide and that are also black. So I select the "2 inch" wide option in the "size" attribute and I also select the "black" option in the "color" attribute.

The search returns ALL items that are in the 2" category (meaning all colors and not just black) and ALSO ALL black products (meaning all sizes and not just 2" wide).

So in short, when you try to narrow the search query by selecting more than one attribute, then search query instead makes the search results broader instead of narrower.

This could be my database, but I think that the attribute data is good. If it is the search script, how do I modify it to do what I am needing it to do?

The problem I think is that the search returns product attributes with the OR operator rather than the AND (e.g. it will search for colour = blue OR size = 10) rather than AND. But I don’t know where I have to change these operators.
I hope you can help me, I’ve tried the whole week but I couldn’t solve the problem but didn’t find any solution.

More...