vendredi 2 janvier 2015

Select array from array mysql


I have two table Table Category (Cate_id, Parent_id)


Cate_id | Parent_ID


1 | 0


3 | 1


2 | 0


4 | 1


And table Products (Product_id, Category_id)


Product_id | Category_id


1 | 1,3


2 | 4


How to select product ID with category_id = 1 and category have parent = 1?





Aucun commentaire:

Enregistrer un commentaire