Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial


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

1 Answer

Andrew Shook
Andrew Shook
31,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.