[nGen.SoNNy]

Hi guys! Can somebody transform this mysql script into SQL ? REP++;

pawn Код:

mysql_store_result();
    while(mysql_fetch_row_format(clanquery,"|"))
    {
        mysql_fetch_field_row(string,"playername");
        format(minfo,sizeof(minfo),"%s\n"W"Name: "G"%s",minfo, string);
    }

[[HiC]TheKiller]

Are you referring to SQLite? You will need to fetch all of the fields separately (no function for the whole row) then use Db_next_row to loop through all of the results.

[nGen.SoNNy]

Can you write the code pls? I don't understand how to make it

[Niko_boy]

Quote:

pawn Код: mysql_store_result();     while(mysql_fetch_row_format(clanquery,"|"))     {         mysql_fetch_field_row(string,"playername");         format(minfo,sizeof(minfo),"%s\n"W"Name: "G"%s",minfo, string);     }

pawn Код:

new DBResult:Result;
        Result = db_query( Database, "SELECT * FROM `table` WHERE A CONDITION" );// clan query here
        for(new i;i<db_num_rows(Result);i++)
        {
            new string[30];
            db_get_field_assoc(Result, "playername",string, 30);
            //db next row to get the next result
                       format(minfo,sizeof(minfo),"%s\n"W"Name: "G"%s",minfo,string );
            db_next_row(Result);
        }

Wasn't much hard to understand just give a proper readingwhat said on wiki
Anyways try that code , i dont know SQLite much still try.