""Arno Kuhl"" <a...@dotcontent.net> wrote in message 
> I have a table with an id and a parentid.
> If it's a top-level record the parentid is 0, otherwise it points to 
> another
> record, and if that record isn't a top-level record its parentid points to
> another record, etc (a linked list).
> Is there a single select that will return the complete list of parentids?

You say you have a parentid and an id - ie, two specific fields in your 
records.  You say that you want to query all the parentids.  Nobody else has 
said this, but why not just

Select unique ids where parentid=0  ?  That gives you (as you say) all your 
top-level records, which are the parents of everything, no?  Or are you 
looking for each id that is itself a parent to something else?  If the 
latter, then why not
  select unique parentid where parentid <> 0  ? 

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to