[Dokins]

pawn Код:

C:\Users\berni\Desktop\Bone County Roleplay\gamemodes\rp.pwn(2386) : error 033: array must be indexed (variable "result")

pawn Код:

MySQL_GetString(sqlid, fieldname[], tablename[])
{
    new query[256], result[256];
    format(query, sizeof(query), "SELECT %s FROM %s WHERE id = %d LIMIT 1", fieldname, tablename, sqlid);
    mysql_query(query);
    mysql_store_result();
    result = mysql_fetch_row(result); // Line with error.
    mysql_free_result();
    return result;
}

[Ash.]

I believe you don't need to assign what mysql_fetch_row() returns. You can just do "mysql_fetch_row(result)", as "result" is passed by reference.

[Dokins]

Thanks, but everytime I try and assign a variable to it, it says:

pawn Код:

C:\Users\berni\Desktop\Bone County Roleplay\gamemodes\rp.pwn(445) : error 047: array sizes do not match, or destination

Variable:

pawn Код:

new result[100];
    result = MySQL_GetString(PlayerSQLID[playerid], "PlayerName", "Accounts");
    SendClientMessage(playerid, COLOUR_GREY, result);

Doesnt work.

[Scenario]

What MySQL plugin are you using?

[Dokins]

R5. @RealCop.

[Scenario]

You may want to try this: https://sampwiki.blast.hk/wiki/MySQL#mysql_fetch_field_row

[Dokins]

I have tried it, but it doesnt return correctly.

[Scenario]

What's it return?

[Dokins]

It doesnt return anything, i've printf'd it several times.

[Scenario]

Did you do this?

pawn Код:

mysql_fetch_field_row(result, fieldname);