MySQL Script to SQL ?
#4

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.
Reply


Messages In This Thread
MySQL Script to SQL ? - by nGen.SoNNy - 19.05.2012, 09:47
Re: MySQL Script to SQL ? - by [HiC]TheKiller - 19.05.2012, 10:14
Re: MySQL Script to SQL ? - by nGen.SoNNy - 20.05.2012, 08:59
Re: MySQL Script to SQL ? - by Niko_boy - 20.05.2012, 09:35

Forum Jump:


Users browsing this thread: 1 Guest(s)