Look up the InnoDB table type: FOREIGN KEY ... ON DELETE CASCADE Btw, what do you mean by "dmx"? Ignatius ____________________________________________ ----- Original Message ----- From: "tbo" <tim@copiousdg.com> To: <php-db@lists.php.net> Sent: Tuesday, May 20, 2003 12:33 AM Subject: delete relational data MYSQL > In php and mysql and dmx, how would one modify the dmx delete record(or > create ones own script) to delete from 2 tables containing "relationships" > data? > > EXAMPLE > a table called Books with Author ID's > a table called Authors with ID's > > how could I delete all the Author's books from the Books table at the same > time I delete that Author out of the Authors table(the Author id would be > passed in the URL as "AID")? > > Any ideas or tutorials? > > -- > Tim Haskins > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php