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 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 > > > Or, if you want to be a little trickier... users table: user_id forename surname DELETE FROM emails_table WHERE user_id = ( SELECT user_id FROM users_table WHERE forename = '$forename' AND surname = '$surname' ) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
