hi ash...
thanks for getting back to me.
my situation isn't that complex, but i'm looking for an efficient method.
i've got a start tbl
universityTBL
the universityTBL can have either
schoolTBL, or
deptTBL
as the next child tbl
the schoolTBL will have
deptTBL
as the child tbl
the deptTBL wil have
classTBL
as the childTBL...
to get around some of the headaches of this approach, i maintain
a mapTBL where i have the parent_uuid,child_uuid as entries
mapTBL
-parent_uuid
-child_uuid
so my issue is that if i have a given parent_uuid, that i want to
delete, as well as the associated leaf/nodes of the parent..
how can this be accomplished?
you can't just start to delete the parent_uuid, as you completely miss
the underlying/associated nodes/leafs for the parent_uuid...
thoughts/comments/etc...
-----Original Message-----
From: Ashley Sheridan [mailto:[email protected]]
Sent: Friday, October 16, 2009 8:38 AM
To: bruce
Cc: [email protected]
Subject: Re: [PHP] How to Delete the parent node, and child nodes/leafs
for a db/tbl in php
On Fri, 2009-10-16 at 08:34 -0700, bruce wrote:
> Hi.
>
> I've got a situation where I have a couple of tables. The relationship
> between the tables is one of parent/child. I'm trying to figure out the
best
> approach to being able to delete the associated children in the child
tbls,
> of a given parentID in the parentTBL...
>
> I've checked into various sites/articles on the 'net.. but i'm not sure
how
> best to accomplish this...
>
> I'm using php as the interface language to the test tbls..
>
> Any pointers/articles/test code (code/schema) would be helpful...
>
> Thanks
>
>
>
Well if the tables truly have a relationship, then no PHP is necessary.
I assume that to connect the 'parent' row with the 'children' rows of
the secondary table you've used an identifying field. For example:
users table:
user_id
forename
surname
emails table:
email_id
user_id
email_address
So in the above example, a user on the users table could have several
entries in the emails table for each email address they have.
emails.user_id will match up users.user_id so you can run a query like
DELETE FROM emails WHERE user_id=id
Is this any help?
Thanks,
Ash
http://www.ashleysheridan.co.uk
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
