T_STRING

[leaboy12]

I'm receiving an error stating that an unexpected T_STRING has occurred on line 53.

 

$db = new DatabaseConnection('xxxxxxx, 'xxxxxx', 'xxxxxxx', 'xxxxxx');

 

$targetList = "INSERT INTO xxxxxx(id, name, list_type, date_entered, date_modified, ";

$targetList .= "modified_user_id, assigned_user_id, created_by) ";

$targetList .= "VALUES('".$target_list_id."', '".$target_list_name."', 'seed', ";

$targetList .= "'".date('Y-m-d H:i:s')."', '".date('Y-m-d H:i:s')."', ";

$targetList .= "'c10e6353-182f-19fc-0c15-478499c79e1c', 'c10e6353-182f-19fc-0c15-478499c79e1c', ";

$targetList .= "'c10e6353-182f-19fc-0c15-478499c79e1c')";

 

    $result = $db->query($targetList); (line 53)

 

I know this error usually occurs when a string is in a quote in the wrong place or using the wrong type of quote but i cant seem to see any problem like that.

 

Help would be appreciated

[JasonLewis]

You're missing a ' here, after the first lot of x's. Not sure if that's because you removed the information or not.

 

$db = new DatabaseConnection('xxxxxxx, 'xxxxxx', 'xxxxxxx', 'xxxxxx');

[leaboy12]

well spotted, the missing quote was from when i added the x's

 

the issue is somewhere else, my search continues

[JasonLewis]

Need to see more code I think...