PDA

View Full Version : MySQL Problem


CoDeZ
26/10/2012, 05:06 PM
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? :/

CoDeZ
26/10/2012, 06:58 PM
Anyone? :/

CoDeZ
27/10/2012, 02:17 PM
pl0x? :(

Vince
27/10/2012, 03:09 PM
Literal strings should be enclosed in single quotes ('), not backticks (`).

CoDeZ
27/10/2012, 03:33 PM
Nothing can describe how am i grateful to you even though that was an epic fail mistake
Thank you, RP++.