Hi want to create a binary tree using table User registration having fields id, parent_id, user_id.
id Parent_id user_id
1 0 110491
2 1 542248
3 1 998128
4 2 518457
5 2 055311
when i enter the user_id and submit it should display the tree for particular user_id. Can anyone please suggest how can i do this.
With Regards
XXXXXXXXX
Hi,
Try reading the following. It covers both ajacency list and nested set tree models.
http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
Even if you're not using MySQL, the principles explained within this article will still be relevant.
R.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.