I am having an obstacle in advanced search hope somebody could help me.
I have made a custom module in the backend like categories , entitled as brands.
I have added the values of the brands in the search fileds of advanced search as well.
I want to modify my search , i want that when a product is search with the text, then the customer can select the brand as well, and hence the search should work.
I have also created the mysql query for the same.
But i am unsure of,where to put the mysql query to get the search.
Hope somebody could navigate me in this.
Thanks In advance