Re-Ordering Nested Tree records in a database

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
kendall
Forum Regular
Posts: 852
Joined: Tue Jul 30, 2002 10:21 am
Location: Trinidad, West Indies
Contact:

Re-Ordering Nested Tree records in a database

Post by kendall »

Hello,

I have been studying the ways of storing hierarchical data in database, and i'm currently experiementing with the "Modified Preorder Tree Traversal" method to build a dynamic menu management system.

My question arises when having to re-order the menu structure in any desired fashion.

How is it possible in the aspects of re-calculating the left and right values...has anyone seen anymore in-depth tuts on this method of sotring data?

Kendall
Post Reply