MySql Updating format - Help please
#9

Quote:
Originally Posted by Death1300
Посмотреть сообщение
I've changed anything that was 'NULL' to a defult number (I.e - 1). I have used quotation marks around the variables yet I still having the same problems. I've expanded the query to 200.

EDIT:

Код:
[21:37:01] CMySQLHandler::Query(UPDATE accounts SET 'Name' = 'death', 'Password' = 'test', 'Cash' = '2000', 'Admin' = '10', 'Kills' = '1', 'Deaths' = '9', 'Skin' = '285', 'DriversLic' = '1', 'Mute' = '1' WHERE 'Faction' = '1') - An error has occured. (Error ID: 1064, 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 ''Name' = 'death', 'Password' = 'test', 'Cash' = '2000', 'Admin' = '10', 'Kills' ' at line 1)
Post the query too.
Reply


Messages In This Thread
MySql Updating format - Help please - by Sledgehammer - 07.02.2014, 19:58
Re: MySql Updating format - Help please - by FireCat - 07.02.2014, 20:01
Re: MySql Updating format - Help please - by judothijs - 07.02.2014, 20:01
Re: MySql Updating format - Help please - by Sledgehammer - 07.02.2014, 20:02
Re: MySql Updating format - Help please - by FireCat - 07.02.2014, 20:06
Re: MySql Updating format - Help please - by Sledgehammer - 07.02.2014, 20:31
Re: MySql Updating format - Help please - by Sledgehammer - 07.02.2014, 21:27
Re: MySql Updating format - Help please - by Riddy - 07.02.2014, 21:33
Re: MySql Updating format - Help please - by Konstantinos - 07.02.2014, 21:34
Re: MySql Updating format - Help please - by Sledgehammer - 07.02.2014, 21:41

Forum Jump:


Users browsing this thread: 1 Guest(s)