Hello, I search how to get a array from a query mysql ?
PHP Code:
new Handle:db;
public sql_init()
{
new sqlhostname[35], sqluser[35], sqlpass[35], sqldbname[35], errcode, error[128];
get_cvar_string("amx_sql_host", sqlhostname, 34);
get_cvar_string("amx_sql_user", sqluser, 34);
get_cvar_string("amx_sql_pass", sqlpass, 34);
get_cvar_string("amx_sql_db", sqldbname, 34);
new Handle:tuple = SQL_MakeDbTuple(sqlhostname, sqluser, sqlpass, sqldbname);
db = SQL_Connect(tuple, errcode, error, charsmax(error));
return PLUGIN_CONTINUE;
}
public end_notemap()
{
new players[32], playerscount;
get_players(players, playerscount, "ch");
for(new i; i < playerscount; i++)
{
new id = players[i];
menu_cancel(id);
}
new Handle:query = SQL_PrepareQuery(db, "SELECT `verygood`, `good`, `bad`, `verybad`, `none` FROM `cs_notemap` WHERE `map`='%s'", g_mapname);
new result[4];
/*
How to get the four result in the arry result ?
*/
g_vote_verygood += result[0];
g_vote_good += result[1];
g_vote_bad += result[2];
g_vote_verybad += result[3];
g_vote_none += result[4];
query = SQL_PrepareQuery(db, "UPDATE `cs_notemap` SET `verygood`='%d', `good`='%d', `bad`='%d', `verybad`='%d', `none`='%d' WHERE `map`='%s'", g_vote_verygood, g_vote_good, g_vote_bad, g_vote_verybad, g_votenone, g_mapname);
SQL_Execute(query);
SQL_FreeHandle(query);
return PLUGIN_HANDLED;
}
Very thank's !
__________________