unexpected T_STRING

[gilmourt]

Hey,

Can anyone help with this error, I've had a look around on web and cant seem to understand why i get this error:
Parse error: parse error, unexpected T_STRING in C:\phpweb\cr\content\items\item_submit.php on line 241

And here is the code surrounding like 241

$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_ID.", low_level_design_ID=".$low_level_design_ID.", data_dictionary_ID=".$data_dictionary_ID.", data_description='".$data_description."', work_package='".$work_package."', work_package_representative='".$work_package_representative."', project_ref='".$project_ref."', benefits='".$benefits."', comments='".$comments."',);

            if(!$sql_create_item_query)
            {
                    // print out the error message
                    $mysql_error_no=mysql_errno();
                    $mysql_error=mysql_error();

(line 241) print "<div align=\"center\" class=\"b_error_text\">Error creating a new item in the ITEMS table for the following reason</b><br>".$mysql_error_no.": ".$mysql_error."</div>";
exit();
}

            // retrieve the ID and live status of the item that has just been created
            $sql_item_query=mysql_query("SELECT items.ID AS ID, environments.live AS live
            FROM items
            LEFT JOIN environments ON items.environment_ID=environments.ID
            ORDER BY items.ID DESC LIMIT 1");

[barand]

Note use of php tags 🙂

project_ref='".$project_ref."', benefits='".$benefits."', comments='".$comments."',); 

if(!$sql_create_item_query) 
{ 
// print out the error message 
$mysql_error_no=mysql_errno(); 
$mysql_error=mysql_error(); 
(line 241) print "<div align=\"center\" class=\"b_error_text\">Error creating a new item in the ITEMS table for the following reason</b><br>".$mysql_error_no.": ".$mysql_error."</div>"; 
exit(); 

There's a " missing at end of first line above.

Also you don't need all those concatenations inside double quotes
$vars are auto expanded inside " " so this will do :

".... project_ref = $project_ref, benefits = '$benefits' , comments = '$comments' )"; 

hth