Jump to content

Syntax error-- insert problem


clay1

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.