[SOLVED] strange "near" problem after server admin updated mysql version

[mforan]

heres the code that is the supposed "problem" note, this code worked before this "mysql update" ? random if u ask me!

 

$query = "INSERT INTO inspect SET cheat='$cheaterdetail[0]',mod='$cheaterdetail[1]',alliance='$cheaterdetail[2]'";

mysql_query($query) or die("Error: ".mysql_error());  

}

 

and the error:

 

Error: 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 'mod='mark',alliance=''' at line 1

[roopurt18]

MOD is a mysql reserved word.  Try enclosing all of your full table and column names in back ticks, the unshifted tilde key.

[charliemexican]

the right sintaxis for  your query would be something like this:

 

$query="INSERT INTO inspect(cheat,mod,alliance) VALUES('$cheaterdetail[0]','$cheaterdetail[1]','$cheaterdetail[2]')";

 

for the insert command on sql its better to specify the fields and later the values you are going to insert. Hope it helps!

[mforan]

yer the mod label was the problem haha. thats random but doesn't surprise me.

 

the new code is great, thanks man!