[Pawn] [Help]How to retrieve data from mysql.

[Radical]

Non-threaded query:

Code:

new Cache: result = mysql_query(ConnectionHandle, "SELECT * FROM `accounts` WHERE `ID` = '10'");

new dest[24], score;

if (cache_num_rows())
{

    cache_get_value_name(0, "Nick", dest, 24);

    cache_get_value_name_int(0, "Score", score);

}

cache_delete(result);

(Recommended) Threaded query:

Code:

mysql_tquery(ConnectionHandle, "SELECT * FROM `accounts` WHERE `ID` = '10'", "OnPlayerDataLoaded", "i", playerid);


forward OnPlayerDataLoaded(playerid);
public OnPlayerDataLoaded(playerid)
{
    if (!cache_num_rows()) {
        return 0;
    }

    new dest[24], score;

    cache_get_value_name(0, "Nick", dest, 24);

    cache_get_value_name_int(0, "Score", score);

    return 1;

}