Jump to content

[SOLVED] SQL Syntax Error 1AT?


socalnate

Recommended Posts

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."); 

 

 

Link to comment
https://forums.phpfreaks.com/topic/75712-solved-sql-syntax-error-1at/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.