Implement custom search statement

[lilcleo001]

Hello everyone.

 

We built a site for car parts and are stuck in a hole rite now. We are trying to change the Select Statement.

 

lets say we searched for the part number: "1111-1111-111"

Lets say its an Alternator. The results will give you 3 that are the same part, just different brands. We've created a separate table and this statement. It will run in the query window. we just need help implementing it to the site/search.

 

Any ideas?

 

+------------------------

select distinct products_to_categories.products_id from products_to_categories where

 

products_to_categories.categories_id in (select products_to_categories.categories_id from products_to_categories left

 

join products on products_to_categories.products_id = products.products_id where products.products_model = "11111111111")

+------------------------