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."'". ")"; 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."', '". 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! Link to comment https://forums.phpfreaks.com/topic/175762-syntax-error-insert-problem/#findComment-926224 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.