/actual url...
-bruce
-Original Message-
From: Peter Brawley [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 02, 2006 2:15 PM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: logic/db question
Bruce,
my question, how can i come up with a sql query that will
hi peter...
tried to get to the link...saw that it's 'localhost'!!
what's the real/actual url...
-bruce
-Original Message-
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 02, 2006 2:15 PM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
S
Bruce,
my question, how can i come up with a sql query that will list all the
children (and children's children...) of a top level item?
This is an edge list tree model, ID being the child node, parentID being
the parent node, the row denoting the edge between ID and parentID.
Unless you kno
hi...
i have a tbl
fooTBL
name
parentID
ID
so a name can have might have a parentID, as well as an ID. 'name's are
associated with other 'name's via the parentID. in other words, if a name's
parentID == a name's ID, name1 is the parent of name2.
ie
nameparentID