[[LCK]Chris]

This might help.

Quote:

#include <a_samp> #include <a_mysql> GetMoney(name[]) { mysql_connect("127.0.0.1", "root", "freshdatabase", ""); new Query[64]; format(Query, 256, "SELECT * FROM accounts WHERE Username='%s'", name); mysql_query(Query); mysql_store_result(); new nMoneyAmount[48]; while(mysql_fetch_row_format(Query,"|")) { mysql_fetch_field_row(nMoneyAmount, "Money"); } return strval(nMoneyAmount); } public OnPlayerCommandText(playerid, cmdtext[]) { new string[48], pMoney; pMoney = GetMoney(pName(playerid)); if(!strcmp(cmdtext, "/mysqltest", true)) { format(string, 48, "Your Money: %i", pMoney); SendClientMessage(playerid, 0xC2A2DAAA, string); return true; } return false; } stock pName(playerid) { new iName[MAX_PLAYER_NAME]; GetPlayerName(playerid, iName, sizeof(iName)); return iName; }