search separate fields

[rainer]

hi, any help appreciated that will bring me further,

i want to implement an advanced search for my catalog, where every single field of the catalog is searched separatly at the same time with different search values in each search-field. all with an AND operator.

so for example i have the fields first name and surename and a search mask, where i can enter a first name and in a separated search-field a surename. when i start the search, both fields will be searched with an AND operator.

any suggestions how to do this?

with regards,
rainer

[thyon]

There is a routine that builds the search based on the "search" get parameter, that portion can be adapted to use AND and OR keywords to build the SQL with AND and OR operators. There are just too many custom features... we'll never get to implement them all....