Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

PHP

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.