Welcome Guest, Not a member yet? Register   Sign In
Left and Right Node in Hierarchical Database
#1

[eluser]1mr3yn[/eluser]
It's almost one month and still can't find the precise algorithm for finding the
Left and Right Nodes of a hierarchical table. I have read the Managing Hierarchical Data in MySQL but the left and Right Nodes are manually inputted. I just want to update the table and insert the left and right nodes value.
#2

[eluser]InsiteFX[/eluser]
This article might help you.

Storing Hierarchical Data in a Database

InsiteFX
#3

[eluser]1mr3yn[/eluser]
Thanks! It's Big Help now im one step closer to the algorithm.
#4

[eluser]CroNiX[/eluser]
search the site for "nested set". Theres a library.




Theme © iAndrew 2016 - Forum software by © MyBB