ok so I have a "test" form that I'm working with trying to update a record in MySQL (I'm fully aware of the sql injections possibilities with this form) so here is my code:

	// database connection //

	include 'db_connect.php';

	include 'data/var/variables.php';
	//Writes the information to the database
		mysql_query("UPDATE tickets SET 	work_performed = $work_performed,
										 	item_qty1 = $item_qty1,
										 	item_qty2 = $item_qty2,
										 	item_qty3 = $item_qty3,
										 	item_qty4 = $item_qty4,
											item_qty5 = $item_qty5,
											manuf_1 = $manuf_1, 
										 	manuf_2 = $manuf_2,	 
											manuf_3 = $manuf_3, 
										 	manuf_4 = $manuf_4,
										 	manuf_5 = $manuf_5,
										 	part_number1 = $part_number1,
										 	part_number2 = $part_number2,
										 	part_number3 = $part_number3,
										 	part_number4 = $part_number4,
										 	part_number5 = $part_number5,
										 	part_description1 = $part_description1, 
		 									part_description2 = $part_description2, 
		 									part_description3 = $part_description3, 
											part_description4 = $part_description4,
		 									part_description5 = $part_description5, 
		 									part_price1 = $part_price1, 
		 									part_price2 = $part_price2, 
		 									part_price3 = $part_price3, 
		 									part_price4 = $part_price4, 
		 									part_price5 = $part_price5,
		 									price_extension1 = $price_extension1, 
		 									price_extension2 = $price_extension2, 
		 									price_extension3 = $price_extension3, 
		 									price_extension4 = $price_extension4, 
		 									price_extension5 = $price_extension5, 
		 									material_total = $material_total, 
		 									sales_tax = $sales_tax, 
		 									shipping_cost = $shipping_cost, 
		 									work_date1 = $work_date1,
		 									work_date2 = $work_date2, 	
											work_date3 = $work_date3, 
		 									work_date4 = $work_date4, 
		 									work_date5 = $work_date5, 
		 									tech_name1 = $tech_name1, 
		 									tech_name2 = $tech_name2, 
		 									tech_name3 = $tech_name3, 
		 									tech_name4 = $tech_name4, 
		 									tech_name5 = $tech_name5, 
											cost_code1 = $cost_code1, 
		 									cost_code2 = $cost_code2, 
		 									cost_code3 = $cost_code3, 
		 									cost_code4 = $cost_code4, 
		 									cost_code5 = $cost_code5, 
		 									pay_rate1 = $pay_rate1, 
		 									pay_rate2 = $pay_rate2, 
		 									pay_rate3 = $pay_rate3, 
		 									pay_rate4 = $pay_rate4,
		 									pay_rate5 = $pay_rate5, 
		 									total_hours1 = $total_hours1, 
		 									total_hours2 = $total_hours2, 
		 									total_hours3 = $total_hours3, 
		 									total_hours4 = $total_hours4, 
		 									total_hours5 = $total_hours5, 
		 									hours_subtotal1 = $hours_subtotal1, 
		 									hours_subtotal2 = $hours_subtotal2, 
		 									hours_subtotal3 = $hours_subtotal3, 
		 									hours_subtotal4 = $hours_subtotal4, 
		 									hours_subtotal5 = $hours_subtotal5, 
		 									total_hours = $total_hours, 
		 									material_total = $material_total, 
		 									labor_cost = $labor_cost, 
		 									grand_total = $grand_total	WHERE `id` = '$id'"); 

	echo mysql_error();
I started this out with apostrophe's around my values then was told I needed back ticks then was told I don't need anything around them at all. Frankly I just want the code to work, I ran a small test script using this code:


include 'db_connect.php';


 mysql_query("UPDATE `test` SET      `city` = '$city', `state` = '$state', `zip` = '$zip' WHERE `id` = '$id'");

and it works fine but when I apply the above code to the code posted above this code all I get is an error stating

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 ' item_qty1 = , item_qty2 = , item_qty3 = ' at line 1

I did get the form to work 1 time but it required me to put a value in every field which I don't want to do but after that one time it hasn't worked since.