Liquid Fire Posted August 9, 2007 Share Posted August 9, 2007 I have a table to hold some information is the 2 other table the link back to the first on by the primary key. is there a way to setup something in the database so that when i delete an entry in the first table, the anything in the other 2 tables the link to the deleted id with automatically get deleted without me having to write the code in php for that? Link to comment https://forums.phpfreaks.com/topic/64131-not-sure-how-to-do-this/ Share on other sites More sharing options...
wildteen88 Posted August 9, 2007 Share Posted August 9, 2007 You will want to use a JOIN on DELETE. I'm am not very good at joins so I can't relay provide an example. JOINS allows you to run queries over multiple tables. Link to comment https://forums.phpfreaks.com/topic/64131-not-sure-how-to-do-this/#findComment-319678 Share on other sites More sharing options...
teng84 Posted August 9, 2007 Share Posted August 9, 2007 if you know how to join for the select then try that in delete like wildteen18 told you all you have to do is to determine the connection of those table and presto you can delete it all in one query Link to comment https://forums.phpfreaks.com/topic/64131-not-sure-how-to-do-this/#findComment-319734 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.