from tree to table

[asooy]

affid upline sponsor
1 0 0
2 1 1
3 1 1
4 2 1
5 2 2
6 3 1
7 3 1
8 4 1
9 4 1
10 5 1

i have table with field and data like above in my database mysql,
and i only can preview that data in tree format

lebel 1 (affid=2)
......................level 2
.....................................level 3
level 1 (affid=3)
......................level 2
.....................................level 3

now i want to preview that data in table, like this
level1 (in table)
level2
level3

can someone help me ???

[wilku]

Can you post some code? I don't think I understand your problem.

1. Run a SELECT * query without WHERE clause.
2. echo table start and header
3. For each returned row, echo one row of a table (while loop)
4. echo table end.

[asooy]

Originally posted by wilku
Can you post some code? I don't think I understand your problem.

1. Run a SELECT * query without WHERE clause.
2. echo table start and header
3. For each returned row, echo one row of a table (while loop)
4. echo table end. [/B]

i only need to preview that data in table like
level 1
level 2
level 3
it like affiliate member with affid have upline and sponsor who