Syntax error

[multipianista]

Hi, when I make a mysql consult it says that there's a syntax error, but I have checked it many times and I don't find the error. This is the consult:

Code: Select all

mysql_query("UPDATE p7lkt_content SET fulltext='$video' WHERE id='$primerid'");
echo mysql_error();

The thing is that if I create another column (exactly equal to 'fulltext', but with another name) it works, but not when I do with 'fulltext'. Where can be the error?

The error says: " 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 'fulltext=' "

Thanks for your time.

[Nobbie]

"FULLTEXT" is a reserved MySQL Word (used for global text search), if you like to give a column the name "fulltext" (case does not matter), you have to enclose the column name into "backticks" (back single quote). In order to avoid collisions between column (or table) names and reserved words, you should either pay more attention or use backticks for all your fields:

Code: Select all

"UPDATE `p7lkt_content` SET `fulltext`='$video' WHERE `id`='$primerid'"

There remains a problem, because using backticks is a "MySQL only" syntax and if you like to bring your application to another SQL appplication, you will struggle with these backticks, as it is NON-ANSI SQL Standard. It is safer not to use reserved words. If you dont plan to change to another SQL, you may of course use backticks, as it provides an easy opportunity not to collide with reserved words.

[multipianista]

Ok it works, thanks. I supposed that it could be the problem but I didn't realise how problems can I have with that syntax. Thanks.