MySQL problem
#1

pawn Код:
format(Query, sizeof(Query), "INSERT INTO Players (Username, Password, Score, IP) VALUES('%s', SHA1('%s'), 0, '%s'", pName, password, IP);
Outcome:

Quote:

[19:08:49] CMySQLHandler::Query(INSERT INTO Players (Username, Password, Score, IP) VALUES('test', SHA1('password'), 0, 'my.ip.here') - 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 '' at line 1)

I also tried `Players` but same error.
Reply


Messages In This Thread
MySQL problem - by spedico - 11.01.2012, 17:10
Re: MySQL problem - by AndreT - 11.01.2012, 17:20
Re: MySQL problem - by spedico - 11.01.2012, 17:24
Re: MySQL problem - by AndreT - 11.01.2012, 17:25
Re: MySQL problem - by spedico - 11.01.2012, 17:28

Forum Jump:


Users browsing this thread: 1 Guest(s)