Problem

[manojsinghrawat]

how to display information in a table in the form of tree
e.g. suppose table contains fields as EmpID, BossID etc.
where BossID is one of the EmployeeID.

if data is :
EmpID BossID
AK001 AK001
AK002 AK001
AK003 AK001
AK004 AK002
AK005 AK002
AK006 AK003
AK007 AK003

So Tree will be

                             AK001
                                 /\
                               /     \
                             /         \
                     AK002        AK003
                         /\                /\
                       /    \            /    \
                     /        \         /      \
              AK004  AK005 AK006 AK007

[LarsLai]

hi!
you can do this with nested sets.
here is one tutorial:
http://www.phpkitchen.com/article.php?story=20030427152620585