socalnate Posted November 2, 2007 Share Posted November 2, 2007 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 More sharing options...
socalnate Posted November 2, 2007 Author Share Posted November 2, 2007 BLAH! I found it.... HERE...wow it is so easy to miss a detail like this. '$credit6type')") Link to comment https://forums.phpfreaks.com/topic/75712-solved-sql-syntax-error-1at/#findComment-383168 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.