[Jstylezzz]

Hey sa-mp,

I have a little problem out here..

I have made a little account system, with This thead.

Now i get this error on registering:

Код:

CMySQLHandler::EscapeString(password); - Escaped 10 characters to password.
[17:24:52] >> mysql_query( Connection handle: 1 )
[17:24:52] CMySQLHandler::Query(INSERT INTO `Users` (Username,Password,Money) VALUES ('Jari_Johnson','password,'0')) - 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 '0')' at line 1)
[17:24:52] OnQueryError() - Called.
[17:24:58] >> mysql_query( Connection handle: 1 )
[17:24:59] CMySQLHandler::Query(UPDATE `Users` SET `Money` = '5000' WHERE `Username` = 'Jari_Johnson' ) - Successfully executed.

Anyone knows what i have to do?
((maybe i am late with posting new things, i'm off to the hairdresser ))

[Dynamic007]

Quote:

Originally Posted by Jari_Johnson* Hey sa-mp, CMySQLHandler::Query(INSERT INTO `Users` (Username,Password,Money) VALUES ('Jari_Johnson','password,'0')) - 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 '0')' at line 1)

INSERT INTO `Users` (Username,Password,Money) VALUES ('%s','%s,'0')

Missing apostrophe ( ' ) after password. Change to:

INSERT INTO `Users` (Username,Password,Money) VALUES ('%s','%s','0')

[Jstylezzz]

Thanks, i will try this!