php/mysql query problem

[Snoozy]

Hey everyone, i keep having this error:

Could not connect: 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 'desc,mg,pg) VALUES ('1','0','Snoozy','teata','1','White','atata','atatata'' at line 1

 

This was just a example as I've been lately just trying and trying with no luck,

 

The script part is:

$appquery = mysql_query("INSERT INTO applications (aid,cid,name,charactername,gender,race,desc,mg,pg) 
			VALUES ('".$_COOKIE['ID']."','$insertid','".$_COOKIE['Username']."','$name','$sex','$race','$description','$mg','$pg')") or die('Could not connect: ' . mysql_error());

[kenrbnsn]

"desc" is a reserved word in MySQL. Either rename your column or surround it with backticks:

<?php
$q = "INSERT INTO applications (aid,cid,name,charactername,gender,race,`desc`,mg,pg) 
			VALUES ('".$_COOKIE['ID']."','$insertid','".$_COOKIE['Username']."','$name','$sex','$race','$description','$mg','$pg')";
$appquery = mysql_query($q) or die('Could not insert using the query, $q:<br> ' . mysql_error());
?>

 

Ken

[Snoozy]

Wow such a simple issue and I've been trying to fix it for 2 hours Oh well now I know that if I ever come across this issue in the future, thank you very much!