[StickP0le]

Ok im making a top15 in my server and it only select one column is there any way to select more than one data this is my code

 // Connect to SQL
    new Handle:SqlConnect = SQL_Connect(g_hTuple, ErrorCode, g_Error, 511)
    
    if(SqlConnect == Empty_Handle)
    {
        log_amx("SQL Error: %s", g_Error)
        set_fail_state(g_Error)
        return PLUGIN_HANDLED;
    }
    
    static nombre[33], kills, infectados
    
    // Create Handle
    new Handle:Query
    Query = SQL_PrepareQuery(SqlConnect, "SELECT `Nombre`, `Kills`, `Infectados` FROM `personajes` ORDER BY `Kills` DESC LIMIT 50")
    
    if (SQL_Execute(Query))
    {
        if (SQL_NumResults(Query))
        {
            SQL_ReadResult(Query, 0, nombre, charsmax(nombre))
            kills = SQL_ReadResult(Query, 1)
            infectados = SQL_ReadResult(Query, 2)
            
        }
    }

[Sylwester]

PHP Code:

 // Connect to SQL
    new Handle:SqlConnect = SQL_Connect(g_hTuple, ErrorCode, g_Error, 511)
    
    if(SqlConnect == Empty_Handle)
    {
        log_amx("SQL Error: %s", g_Error)
        set_fail_state(g_Error)
        return PLUGIN_HANDLED;
    }
    
    static nombre[50][33], kills[50], infectados[50]
    new cnt
    
    // Create Handle
    new Handle:Query
    Query = SQL_PrepareQuery(SqlConnect, "SELECT `Nombre`, `Kills`, `Infectados` FROM `personajes` ORDER BY `Kills` DESC LIMIT 50")
    
    if (SQL_Execute(Query))
    {
        while (SQL_MoreResults(Query))
        {
            SQL_ReadResult(Query, 0, nombre[cnt], charsmax(nombre[]))
            kills[cnt] = SQL_ReadResult(Query, 1)
            infectados[cnt] = SQL_ReadResult(Query, 2)
            cnt++
            SQL_NextRow(Query)
        }
    } 


[StickP0le]

thanks man you are the best

[StickP0le]

EDIT: im getting this error

 
L 01/20/2012 - 02:30:22: [MySQL] Invalid column: 2
L 01/20/2012 - 02:30:22: [AMXX] Displaying debug trace (plugin "zombie_plague40.amxx")
L 01/20/2012 - 02:30:22: [AMXX] Run time error 10: native error (native "SQL_ReadResult")
L 01/20/2012 - 02:30:22: [AMXX]    [0] zombie_plague40.sma::show_menu_jugadores (line 10862)

[Sylwester]

It means that you used SQL_ReadResult(Query, 2) to read results of a query that returned less than 3 columns.

[StickP0le]

ok, thanks man i´ll try adding more columns to the database

[StickP0le]

i tried adding one more column and still get this error

[Sylwester]

It's not about how many columns you have in database table, but how many you retrieve with query.

PHP Code:

SELECT `col1` FROM `table_name` ... //<-- this retrieves data only from 1 column
SELECT `col1`,`col2`,`col3` FROM `table_name`... //<-- this retrieves data from 3 columns
SELECT * FROM `table_name` ... //<-- this retrieves data from all columns 


[StickP0le]

ohh, my bad, i will try that