Who8MyFish Posted May 13, 2011 Share Posted May 13, 2011 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 'with codes VALUES ('pocketstest1@localhost', 'pockets', 'one')' at line 1 "INSERT INTO $B VALUES ('".$subscriber_data[3]."', '".$subscriber_data[5]."', '".$subscriber_data[6]."')" This worked perfectly earlier today I swear. Am I missing something or am i looking in the wrong place? Quote Link to comment https://forums.phpfreaks.com/topic/236357-syntax-rage/ Share on other sites More sharing options...
gizmola Posted May 13, 2011 Share Posted May 13, 2011 $B should be a table name but instead it is: "with codes". Quote Link to comment https://forums.phpfreaks.com/topic/236357-syntax-rage/#findComment-1215190 Share on other sites More sharing options...
Who8MyFish Posted May 13, 2011 Author Share Posted May 13, 2011 I should have explained that all of the variables in the query are being posted from another page "with codes" is the name of the table. $B = addslashes($_POST['campaign_name']); Quote Link to comment https://forums.phpfreaks.com/topic/236357-syntax-rage/#findComment-1215197 Share on other sites More sharing options...
Maq Posted May 13, 2011 Share Posted May 13, 2011 If your table name actually contains space(s) (which it shouldn't) then you must put backtics around it `with codes`. Quote Link to comment https://forums.phpfreaks.com/topic/236357-syntax-rage/#findComment-1215200 Share on other sites More sharing options...
Who8MyFish Posted May 13, 2011 Author Share Posted May 13, 2011 KA-FIXED! So the spaces in my table names are causing the problem. Alright that might explain some other problems I've had. thanks guys I'll RE RE evaluate the way my tables are managed to avoid using spaces. I'm new to php and MySQL and I'm throwing together a simple Customer Relationship Management (CRM) site as an experiment/ learning experience. Quote Link to comment https://forums.phpfreaks.com/topic/236357-syntax-rage/#findComment-1215202 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.