Re: from tree/hirarki format to table format

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