gistfile1.txt

3 tables: Product, Category, ProductCategory

A product has many categories and a category can belong to many products.
The category objet is nestedset(via doctrine behavior) with a parent, and a position.

I need to be able to manage these categories (up/down/delete/new/edit)
I need to be able to add many categories to a product.

AFAIK, when a category (cat1) has a parent (cat0), and you want to add cat1 to a product, you need to add cat0 too.

Is there a simple way to handle these recommandation?

Thanks a lot ^â 

• The assertion is true :)
• Yes, doctrine 1.2
• So, All categories, including the parent if the category has at least one product.
• schema : https://gist.github.com/da6be3b29bb9acb3125e
• OK ^^

Thanks a lot!