[PHP] How to Delete the parent node, and child nodes/leafs for a db/tbl in php

2009-10-16 Thread bruce
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

Re: [PHP] How to Delete the parent node, and child nodes/leafs for a db/tbl in php

2009-10-16 Thread Ashley Sheridan
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

RE: [PHP] How to Delete the parent node, and child nodes/leafs for a db/tbl in php

2009-10-16 Thread bruce
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

Re: [PHP] How to Delete the parent node, and child nodes/leafs for a db/tbl in php

2009-10-16 Thread David Otton
2009/10/16 bruce bedoug...@earthlink.net: 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

Re: [PHP] How to Delete the parent node, and child nodes/leafs for a db/tbl in php

2009-10-16 Thread Jim Lucas
Ashley Sheridan wrote: 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