Mutley Posted February 27, 2007 Share Posted February 27, 2007 DELETE * FROM ipb_tablesmembers AS mem JOIN ipb_tablespfields_content AS fld ON mem.name = fld.field_1 WHERE posts < '1' AND time_offset = '-12' You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM ipb_tablesmembers AS mem JOIN ipb_tablespfields_content AS fld ON mem.n' at line 1 Any ideas? Quote Link to comment https://forums.phpfreaks.com/topic/40405-problem/ Share on other sites More sharing options...
fenway Posted February 27, 2007 Share Posted February 27, 2007 Drop the '*'. Quote Link to comment https://forums.phpfreaks.com/topic/40405-problem/#findComment-195533 Share on other sites More sharing options...
artacus Posted February 27, 2007 Share Posted February 27, 2007 OR if you only want to delete from 1 table or the other DELETE mem, fld FROM ... Quote Link to comment https://forums.phpfreaks.com/topic/40405-problem/#findComment-195543 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.