Adding 1 to a field in MySQL

yesiamhe

New Member
I have a MySQL query I'm running. I want to add \[code\]1\[/code\] to a field called \[code\]articleswritten\[/code\].I get this error: \[quote\] 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 ''users' SET articleswritten = articleswritten + 1 WHERE \[code\]id\[/code\] = '1'' at line 1\[/quote\]Code:\[code\]$sql = "UPDATE 'users' SET articleswritten = articleswritten + 1 WHERE `id` = '$userid'";$result = mysql_query($sql) or die(mysql_error());\[/code\]I can't find an issue. Am I blind?Any help would be appreciated.
 
Top