Page 1 of 1

managing hierarchical data ??

Posted: Mon Sep 10, 2007 10:54 pm
by PHPycho
Hello forums !!
I have some few questions regarding storing hierarchical datas in the table.
I would like to store hierarchical data in following table format
id | title | parent_id

I would like to know , whats the effective means of editing, adding , deleting the hierarchical datas, what i mean is how they should be displayed and operation should be performed.
Thanks in advance to all of you.

Posted: Mon Sep 10, 2007 10:59 pm
by s.dot
This was a hard concept for me to grasp (well, the modified preorder tree traversal), but once I got it - it serves its purpose very well.

Good article here: http://www.sitepoint.com/article/hierar ... a-database