Google
  Web www.spinics.net

Re: Re: Listing parent ids

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


""Arno Kuhl"" <arno@xxxxxxxxxxxxxx> wrote in message 
news:DB930522404B4552B8A15AF991C57E30@point01...
>
> Hi Jim. Only one linked list of parentids. No siblings.
> Multiple records can have the same parentid, but that doesn't play a role.
>

Okay.  So you want only one 'family tree' at any given time, and a tree is a 
straight line, ie, it has no branches.

Sounds to me like a loop surrounding a query that seeks out a specific id 
which is continually re-evaluated from the last-read record's parentid.  As 
each query result is obtained (one record), the pair of keys is saved in an 
array.

Curiousity has me asking - what are the contents of these records that such 
a structure works?  To me, this 'parentid' sounds like a foreign key, which 
is usually used to read a separate table in a normalized db.    Your 
response that "multiple records can have the same parentid" is the same as a 
"1-M" relationship, which implies the need for normalization.  Apparently 
your situation has normalized everything(?) into one table. 



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



[PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Plagiarism Notes]     [Postgresql]     [Yosemite News]

Powered by Linux