MPTtree, Hieararchical trees in a database table

[eluser]m4rw3r[/eluser]
Another good thing with nested sets is that they can easily be paced in a certain order (not bound to sorting by columns).

If you want to make a CMS, look at the wiki example above. The example has a lot of flaws (Not able of having two pages with the same names as children to the same node, for example (has nothing to do with MPTtree, it's how I implemented the easy searching by title in the controller)), but it is something that might point you in the right direction.

I'm also making a CMS with MPTtree, something reminding of Radiant CMS (I like the simplicity in the Radius tags), so don't hesitate to ask .