MySQL problem
#9

Quote:
Originally Posted by FireCat
Посмотреть сообщение
I'm not using " for integers, I'm using '
And I found the problem!
It was the size of the variable (cells)
pawn Код:
[17:26:48] CMySQLHandler::Query(UPDATE `Accounts` SET `TrashMasterMissions` = '3' WHERE `ID) - An error has occured. (Error ID: 1054, Unknown column 'ID' in 'where clause')
Well good for you! Now for the love of Christ, never ever ever put integer value inside single quotes like this:
SELECT * FROM `some_table` WHERE `something` = '1'. NO, you don't do it like that, you never put integers inside single quotes like you do with strings, ask anyone you want. Instead you make it like this: SELECT * FROM `some_table` WHERE `something` = 1
Reply


Messages In This Thread
MySQL problem - by FireCat - 28.07.2012, 15:56
Re: MySQL problem - by Sanady - 28.07.2012, 16:00
Re: MySQL problem - by FireCat - 28.07.2012, 16:01
Re: MySQL problem - by Sanady - 28.07.2012, 16:05
Re: MySQL problem - by Virtual1ty - 28.07.2012, 16:10
Re: MySQL problem - by FireCat - 28.07.2012, 16:13
Re: MySQL problem - by Virtual1ty - 28.07.2012, 16:14
Re: MySQL problem - by FireCat - 28.07.2012, 16:17
Re: MySQL problem - by Virtual1ty - 28.07.2012, 16:20

Forum Jump:


Users browsing this thread: 1 Guest(s)