What is the best way to implement a product filter for ecommerce?

Question

PHP

At the moment I have two tables, one with products, the second with the attributes of these same products, linked by a foreign key. But I can’t imagine how to organize kosher filtering for these products, based, among other things, on their attributes.

Answer 1

JOIN cancelled? or I don't understand the question?