error in mySQL syntax?

[trajik]

solved can close the thread

Edited July 5, 2010 by Guest

[MaddDogg]

"character" or "CHARACTER" is a predefined keyword in MySQL.

You need to use a different column/field name.

I've also had this problem once, with the keyword "read", so I just needed to change it to "hasRead", but until I found this out, it already drove me crazy

Here is a list of the keywords/reserved words:

http://dev.mysql.com/doc/refman/4.1/en/ ... words.html

[trajik]

Thanks that was it it worked it was driving me crazy thank you again

[dzek (varez)]

put you column name in ->> ` <--- this chars (quotes) (one the left from "1" key on keyboard)

like

Select `character` from `mytable` where id='5'