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? 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 '*'. 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 ... Link to comment https://forums.phpfreaks.com/topic/40405-problem/#findComment-195543 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.