| 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 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.
Description: 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!