Hi,
Im getting an error 1064 which is a ER_PARSE_ERROR, i know its something to do with my Insert query but cant work out what.
See the query is really long and spans across 2 lines when coding, I just hit return and went to next line is that correct?
Also im not sure when i should be using
two sets of quotes title='".$title."'
one set of quotes solution_summary=".$solution_summary."
Any ideas?
$sql_create_item_query=mysql_query("INSERT INTO items SET item_types_ID=".$item_type.", title='".$title."', description='".htmlspecialchars($description)."', functional_area_ID=".$functional_area.", created=NOW(), creator_ID=".$global_user_ID.", environment_ID=".$environment.",severity_ID=".$severity.", urgency_ID=".$urgency.", assigned_to_ID=".$assigned_to.", status_ID=".$status.", solution_summary=".$solution_summary.", approval_number=".$approval_number.", required_by_date=".$required_by_date.", reason_for_required_date=".$reason_for_required_date.", estimated_completion_date=".$estimated_completion_date.", archive_date=".$archive_date.", production_date=".$production_date.", deletion_date=".$deletion_date.", cr_closed_date=".$cr_closed_date.", mandays=".$mandays.", cost_estimated=".$cost_estimated.", cost_actual=".$cost_actual.", testing_mandays=".$testing_mandays.", testing_costs=".$testing_costs.", processing_costs=".$processing_costs.", lead_customer=".$lead_customer."
supplier_lead=".$supplier_lead.", supplier_owner=".$supplier_owner.", cr_removed=".$cr_removed.", interdependencies=".$interdependencies.", niku_code=".$niku_code.", mbap_number=".$mbap_number.", supplier_owner=".$supplier_owner.", high_level_design_ID=".$high_level_design.", low_level_design_ID=".$low_level_design.", data_dictionary_ID=".$data_dictionary.", data_description=".$data_description.", work_package=".$work_package.", work_package_representative=".$work_package_representative.", project_ref=".$project_ref.", benefits=".$benefits.", comments=".$comments."");😕 😕 😕
