[snip] > At one point you indicated all the data was coming from one table. Can you send me the table fields and indicate which fields are used to determine parent child relationship? Also 2 sample rows of data which have a relationship would be helpful. [/snip] Columns - tier1, tier2, tier3, tier4 etc. (ends with tier14) Children of tier1 are tier2 - select distinct tier2 from table where tier1 = "foo" and company = "1" select distinct tier2 from table where tier1 = "bar" and company = "1" etc. Children of tier2 are tier3, etc. tier1 tier2 tier3 1, executive, ceo, ceo 1, executive, vp-ops, vp-ops 1, executive, vp-admin, vp-admin mgr 1, executive, vp-admin, vp-admin ops mgr 1, executive, vp-admin, vp-admin mgr 1, executive, vp-admin, vp-admin clerk 1, professional pro-mgr pro-admin 1, professional pro-IT pro-dev 1, professional pro-IT pro-infra 1, professional pro-IT pro-dev 1, technician tech-admin tech-admin mgr 1, technician tech-ops tech-ops mgr Thanks for all of your help. I know I am being a PITA. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
