17.09.2012, 07:18
There are some words that are reserved by MySQL, so doing this:
Wouldn't work. Why? The word Points contains a word (int) which is reserved by MySQL.
Therefore, that query won't be executed, and an error will be logged into mysql_log.txt.
Here's the correct way:
You must include the backtick character before and after a table/field name.
pawn Код:
mysql_query("UPDATE `accounts` SET Points = '50' ...");
Therefore, that query won't be executed, and an error will be logged into mysql_log.txt.
Here's the correct way:
pawn Код:
mysql_query("UPDATE `accounts` SET `Points` = '50' ...");