Welcome to the Treehouse Community
Looking to learn something new?
Nested categories , PHP
Hello everyone , I had really hard time making nested categories in my site, And I have searched all over for that topic, What is the best way of making plenty of categories? one inside another with database ? MySQL
Andrew Shook31,709 Points
It all depends on how you have your database set up right now, but there are two different ways you could go about making nested categories. You could create a column on the category table called "parent" or you could create a separate table called "category_relationships". The category_relationships table would need a UID, a parent, a child, and possible an order column.