Make a multi-sublevel category system

[nonexistentera]

I have thought out how I can layout the database, but have no idea on how I can get it to work with php.

 

The database is layed out using id's, the top of the levels are the 100's (100, 200, 300)

and the sub level's are based throughout the ten's section (100, 110, 120).

Then another level is added using the one's(101,102,103) corresponding to Good, bad, and alright for each of the sub-levels.

 

ex

Tree1(100)

-Root1(110)

--Good Root(111)

--Bad Root(112)

--Alright Root(113)

-Root2(120)

--Good Root(121)

--Bad Root(122)

--Alright Root(123)

 

This is the best way I have been able to think of a good way to layout the categories.

 

If there is a better way, I would be very grateful, as I have gone tooth and nail trying to find a way to get this to work.

 

All comments happily accepted

 

-nonexistentera