MySQL Problem - Printable Version

MySQL Problem - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL Problem (/showthread.php?tid=387879)

MySQL Problem - CoDeZ - 26.10.2012

pawn Код:

format(Query,sizeof(Query),"SELECT * FROM playerdata WHERE Name=`%s` LIMIT 1",GetName(playerid));
    mysql_function_query(MySQLConnection,Query,true,"RFMySQL_CheckAccount","i",playerid);

This is the code

and this is mysql debug log

Код:

[19:16:04] Passing query SELECT * FROM playerdata WHERE Name=`CoDeZ` LIMIT 1 | i
[19:16:04] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()

What's wrong? :/

Re: MySQL Problem - CoDeZ - 26.10.2012

Anyone? :/

Re: MySQL Problem - CoDeZ - 27.10.2012

pl0x?

Re: MySQL Problem - Vince - 27.10.2012

Literal strings should be enclosed in single quotes ('), not backticks (`).

Re: MySQL Problem - CoDeZ - 27.10.2012

Nothing can describe how am i grateful to you even though that was an epic fail mistake
Thank you, RP++.