[caoraivoso3]

well i want to save a string on mysql but i dont know how. i am using blueg plugin. any help?
thanks

[DanishHaq]

pawn Код:

format(query, sizeof(query), "UPDATE `table` SET `column`='%s' WHERE `row`='%s'", var1, var2);

So, for example:

pawn Код:

new userid = PlayerData[playerid][pID];
new playername[MAX_PLAYER_NAME];
GetPlayerName(playerid, playername, sizeof(playername));
format(query, sizeof(query), "UPDATE `rp_users` SET `user_name`='%s' WHERE `user_id`='%d'", playername, userid);

[caoraivoso3]

thanks and how can i load it?

[Patrick]

depends, on what version you MySQL is.

[caoraivoso3]

i am runing on r31

it gives me a error when saving [11:40:37] [ERROR] CMySQLQuery::Execute[SendQuery()] - (error #1054) Unknown column 'Nao' in 'field list'

[Patrick]

MySQL r7+ uses cache, this tutorial might help you: https://sampforum.blast.hk/showthread.php?tid=337810

[caoraivoso3]

thanks but do you know why these error occurs: [11:40:37] [ERROR] CMySQLQuery::Execute[SendQuery()] - (error #1054) Unknown column 'Nao' in 'field list'

[caoraivoso3]

anyone?