ThunderAI Posted September 10, 2008 Share Posted September 10, 2008 What do i do here. I have a parent table and a child table and I want to delete both at the same time otherwise i get a forgien key error. What is this suppose to look like? $sql = "DELETE FROM tbl_users_searchs, tbl_users_notice INNER JOIN tbl_users_notice ON tbl_users_notice.user_n_sub_id = tbl_users_searchs.user_s_id WHERE user_s_archived_yn = 1 AND user_n_archived_yn = 1"; Link to comment https://forums.phpfreaks.com/topic/123611-delete-sql-syntax-not-working/ Share on other sites More sharing options...
JonnoTheDev Posted September 10, 2008 Share Posted September 10, 2008 No, just run 2 queries, 1 for each table to keep it simple Link to comment https://forums.phpfreaks.com/topic/123611-delete-sql-syntax-not-working/#findComment-638333 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.