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"; Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.