how to display data through horizontal tree view in the following way:
Diagram :
Z
-----------------
Y X
---------- ----------
B C D E
------ ------ ------- -------
M N O P Q R S T
Data Stored in Table :
MemID --- | SponsorID -------- | MemID -------- | SponsorID
Z -------- | N/A -------------- | M --------------| B
Y -------- | Z ---------------- | N --------------| B
X -------- | Z ---------------- | O --------------| C
B -------- | X ---------------- | P --------------| C
C -------- | X ---------------- | Q --------------| D
D -------- | Y ---------------- | R --------------| R
E -------- | Y ---------------- | S --------------| E
Diagram :
Z
-----------------
Y X
---------- ----------
B C D E
------ ------ ------- -------
M N O P Q R S T
Data Stored in Table :
MemID --- | SponsorID -------- | MemID -------- | SponsorID
Z -------- | N/A -------------- | M --------------| B
Y -------- | Z ---------------- | N --------------| B
X -------- | Z ---------------- | O --------------| C
B -------- | X ---------------- | P --------------| C
C -------- | X ---------------- | Q --------------| D
D -------- | Y ---------------- | R --------------| R
E -------- | Y ---------------- | S --------------| E
Last edited: