managing hierarchical data ??

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
PHPycho
Forum Contributor
Posts: 336
Joined: Fri Jan 06, 2006 12:37 pm

managing hierarchical data ??

Post 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.
User avatar
s.dot
Tranquility In Moderation
Posts: 5001
Joined: Sun Feb 06, 2005 7:18 pm
Location: Indiana

Post 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
Set Search Time - A google chrome extension. When you search only results from the past year (or set time period) are displayed. Helps tremendously when using new technologies to avoid outdated results.
Post Reply