¡@
php Programming Glossary: root_idAchieve hierarchy, Parent/Child Relationship in an effective and easy way http://stackoverflow.com/questions/11064913/achieve-hierarchy-parent-child-relationship-in-an-effective-and-easy-way parent_id like in Adjacency List but they also store a root_id column. Every member of a given tree has the same value for.. Every member of a given tree has the same value for root_id which is the highest ancestor node in its tree. Then it's easy.. to fetch a whole tree in one query SELECT FROM site WHERE root_id 123 Then your application fetches all the nodes back from the..
How to generate a tree view from this result set based on Tree Traversal Algorithm? http://stackoverflow.com/questions/3638551/how-to-generate-a-tree-view-from-this-result-set-based-on-tree-traversal-algorit NOT NULL auto_increment `category_id` int 11 default NULL `root_id` int 11 default NULL `name` varchar 100 collate utf8_unicode_ci.. KEY `category_id` `category_id` KEY `lft` `lft` `rht` KEY `root_id` `root_id` Based on this question http stackoverflow.com questions.. `category_id` KEY `lft` `lft` `rht` KEY `root_id` `root_id` Based on this question http stackoverflow.com questions 1310649..
|