[SOLVED] SQL Syntax Error 1AT?

[socalnate]

I'm debugging a script and I get this SQL error but I'm scratching my head wondering why I'm getting it?  Anybody know?  I'm just not seeing it...

:-\

 

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 '' at line 1AT 781 credit_insert query.

 

$title_name = mysql_real_escape_string($title_name); 
$credit1 = mysql_real_escape_string($credit1); 
$credit1type = mysql_real_escape_string($credit1type);
$credit2 = mysql_real_escape_string($credit2); 
$credit2type = mysql_real_escape_string($credit2type);
$credit3 = mysql_real_escape_string($credit3); 
$credit3type = mysql_real_escape_string($credit3type);
$credit4 = mysql_real_escape_string($credit4); 
$credit4type = mysql_real_escape_string($credit4type);
$credit5 = mysql_real_escape_string($credit5); 
$credit5type = mysql_real_escape_string($credit5type);
$credit6 = mysql_real_escape_string($credit6); 
$credit6type = mysql_real_escape_string($credit6type);

$credit_insert = mysql_query("INSERT INTO eg_credits(`id`, `title_name`, `user_name`, `ip`, `credit1`, `credit1type`, `credit2`,`credit2type`, `credit3`, `credit3type`, `credit4`, `credit4type`, `credit5`, `credit5type`, `credit6`, `credit6type`) VALUES ('$id', '$title_name', '$submit_user_name', '$ip', '$credit1', '$credit1type', '$credit2', '$credit2type', '$credit3', '$credit3type', '$credit4', '$credit4type', '$credit5', '$credit5type', '$credit6', '$credit6type'") or die (mysql_error() . "AT 781 credit_insert query."); 

 

 

[socalnate]

BLAH!  I  found it....

 

HERE...wow it is so easy to miss a detail like this.   

 

'$credit6type')")