clay1 Posted September 28, 2009 Share Posted September 28, 2009 I added 3 new fields to an insert statement and keep getting this error: 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 '312-577-0000', '2', 'Tuesday, September 29th')' at line 1 The three new fields are the last 3. "INSERT INTO free_for_all_payment () ". "VALUES ('','". $partyid."', '". $Name."', '". $main_gender."', '". $txtAddress."', '". $second_billing_address."', '". $billingCity."', '". $billingState."', '". $billingZip."', '". $billingCountry."', '". $billingTelephone."', '". $billingEmail."', '". $Special_requests."', '". $age."', '". $occupation."', '". $ageFrom."', '". $ageEnd."', '". $relationship_goal."', '". $ss_social_situation."', '". $ss_children."', '". $ss_date_with_children."', '". $ss_like_to_have_children."', '". $ss_ways_met_people."', '". $ss_online_dating_issues."', '". $other_issues."', '". $textfield."', '". $ss_important_traits."', '". $ss_three_biggest_turn_offs."', '". $ss_previous_problems."', '". $ss_previous_problems_desc."', '". $ss_local_contact."'". $Telephone2."', '". $Income."', '". $date."'". ")"; Quote Link to comment https://forums.phpfreaks.com/topic/175762-syntax-error-insert-problem/ Share on other sites More sharing options...
Zyx Posted September 28, 2009 Share Posted September 28, 2009 $ss_local_contact."'". I think there should be: $ss_local_contact."', '". Quote Link to comment https://forums.phpfreaks.com/topic/175762-syntax-error-insert-problem/#findComment-926221 Share on other sites More sharing options...
clay1 Posted September 28, 2009 Author Share Posted September 28, 2009 I think you are right! Quote Link to comment https://forums.phpfreaks.com/topic/175762-syntax-error-insert-problem/#findComment-926224 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.