Home > Article > Backend Development > Shopping mall multi-attribute filtering, how to search! !
Shopping mall multi-attribute filtering, how to search! !
- WBOYOriginal
- 2016-10-17 09:30:051133browse
Multi-attribute filtering for shopping malls, how to search! !
As shown in the picture, I want to find products with attr_id=8 equal to 2.2*2.0m and attr_id=10 equal to leather art bed
Reply content:
Multi-attribute filtering for shopping malls, how to search! !
As shown in the picture, I want to find products with attr_id=8 equal to 2.2*2.0m and attr_id=10 equal to leather art bed
First explain clearly the relationship between the two tables, which is the foreign key, which field in the table corresponds to which field in the other table; mainly use the multi-table joint query join statement
Aren’t the attr_id of table 1 and the attr_id of table 2 the same id? Or is your question wrong?