[Dokins]

Basically, I'm trying to retrieve the Crime from the database to display in a dialog which can then be clicked, however it displays an empty dialog can anyone assist me?

pawn Код:

else if(dialogid == DIALOG_SHOWPERSON)   
            {
                if(response == 0) 
                {
                    return 1;
                }
                else 
                {
                    new string[256];
                    format(string, sizeof(string), "SELECT * FROM `arecords` WHERE `PSQLID` = %d ORDER BY `id` DESC LIMIT 10", psql[playerid]);
                    mysql_tquery(dbHandle, string, "GetRecord", "i", playerid);
                }
            }

pawn Код:

forward GetRecord(playerid);
public GetRecord(playerid)
{
    new r_msg[256], dialogstring[256], Rows = cache_get_row_count( );

    if(Rows < 1)return SendClientMessage(playerid, COLOUR_GREY, "No records found.");
    printf("%d rows", Rows);
    for(new n = 0; n < Rows; n++)
    {
        cache_get_row(n, 0, r_msg);
        sscanf(r_msg, "p<|>e<iiiis[24]iiii>", PlayerArrests[n]);
        cache_get_field_content(n, "Crime", PlayerArrests[n][ar_cr], 24);
        if(n == 0)
        {
            format(dialogstring, sizeof(dialogstring), ""#COL_WHITE"%s", PlayerArrests[n][ar_cr]);
        }
        else
        {
            format(dialogstring, sizeof(dialogstring), "%s\n"#COL_WHITE"%s", dialogstring, PlayerArrests[n][ar_cr]);
        }
    }

    strcpy(Pdialogstring[playerid], dialogstring, 200);
    ShowPlayerDialog(playerid, DIALOG_RECORDS, DIALOG_STYLE_LIST, "Showing 10 Latest Records.", dialogstring, "Select", "Back");
    return 1;
}