I am building an e-commerce site for motor accesories. The idea is that the users selects their product and then their car type and model. I would like to show only products that apply to that model.
My database is structured like:
CAR MAKES TABLE (eg Ford)
CAR MODELS TABLE (eg Escort)
So in English I would like to show:
FROM PRODUCTS TABLE
WHERE ModelID NOT IN ProductModels
Is this possible?