|
|
Posted by "Richard Lynch" on 07/11/05 12:28
On Thu, July 7, 2005 5:36 pm, Feriyanto said:
> 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
>
> Level 1 : affid 2
>
> ........Level 2 : affid 4
>
> ........Level 2 : affid 5
>
> Level 1 : affid 3
>
> ........Level 2 : affid 6
>
> ........Level 2 : affid 7
>
> now i want to preview that data in table, like this
> level1 (in table)
> level2
> level3
>
> can someone help me ???
>
> it affiliate view downline but in table format not in hirarki/tree format
> where affid is have upline and sponsor.
You can probably do this in SQL faster than in PHP.
So Google for "MySQL hierarchy" and "MySQL tree"
--
Like Music?
http://l-i-e.com/artists.htm
Navigation:
[Reply to this message]
|