Bug #53217 UPDATE Syntax Error
Submitted: 27 Apr 2010 17:59 Modified: 27 Apr 2010 19:59
Reporter: Adrian Brojbeanu Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Server: Query Cache Severity:S1 (Critical)
Version:5.1.46 OS:Microsoft Windows
Assigned to: CPU Architecture:Any
Tags: error, error, MySQL, php, query, SQL, syntax, UPDATE

[27 Apr 2010 17:59] Adrian Brojbeanu
PHP Code :

$charid = $selectchar2['id'];
$userid = $select['id'];

$update2 = mysql_query("UPDATE users SET character = '".$charid."' WHERE id = '".$userid."'") or die(mysql_error());


Error Message : 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 'character = '17' WHERE id = '3'' at line 1

I don't know how to fix this....

How to repeat:
Execute the query : UPDATE users SET character = '".$charid."' WHERE id = '".$userid."'

Suggested fix:
I don't know!
[27 Apr 2010 19:59] Sveta Smirnova
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.