Thursday, 15 September 2011

sql - Incorrect syntax - fails to write to second table -



sql - Incorrect syntax - fails to write to second table -

$sql .= "insert logcopy (callname,callstno,callstdir,callstreet,callissue,callmisc,callphone,status,date,dataentry, [key]) values ("; $sql .= "'".$values['callname']."', "; $sql .= "'".$values['callstno']."', "; $sql .= "'".$values['callstdir']."', "; $sql .= "'".$values['callstreet']."', "; $sql .= "'".$values['callissue']."', "; $sql .= "'".$values['callmisc']."', "; $sql .= "'".$values['callphone']."', "; $sql .= "'".$values['status']."', "; $sql .= "'".$values['date']."', "; $sql .= "'".$values['dataentry']."', "; $sql .= "".$keys['key'].""; $sql .= ")"; customquery($sql); homecoming true;

this syntax failing insert values different table called logcopy, cannot find syntax failing.

sql syntax

No comments:

Post a Comment