> Hi Jim. I wanted the list of related parentids from current id to > top-level > (parentid=0). Ahhhhh - now that is a much different question! >From your statement above, are you now saying you only want ONE list of related ids, not the entire society of possible 'families' in your table? Also - do your parent records have multiple children? -- Hi Jim. Only one linked list of parentids. No siblings. Multiple records can have the same parentid, but that doesn't play a role. Cheers Arno -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php