[dFF]

For example i have:

PHP Code:

public MySqlFunction( FailState, Handle:Query, Error[ ], Errcode, Data[ ], DataSize )
{
    switch( FailState )
    {
        case TQUERY_CONNECT_FAILED:
        {
           set_fail_state( "TQUERY_CONNECT_FAILED" )
        }
        
        case TQUERY_QUERY_FAILED:
        {
            set_fail_state( "TQUERY_QUERY_FAILED" )
        }
    }
    
    if( Errcode )
    {
        set_fail_state( "ERRCODE" )
    }

    new id
    id = Data[ 0 ]
    
    if( ~IsConnected( id ) )
        return PLUGIN_HANDLED
    
    if( SQL_NumResults( Query ) < 1 )
    {
        // do something else
    }
    else
    {
        g_iPlayerValue[ id ] = SQL_ReadResult( Query, SQL_FieldNameToNum( Query, "player_value" ) )
    }

    return PLUGIN_CONTINUE
} 


will not better if i cached value for SQL_FieldNameToNum ? (for optimization) Example:

PHP Code:

public MySqlFunction( FailState, Handle:Query, Error[ ], Errcode, Data[ ], DataSize )
{
    switch( FailState )
    {
        case TQUERY_CONNECT_FAILED:
        {
           set_fail_state( "TQUERY_CONNECT_FAILED" )
        }
        
        case TQUERY_QUERY_FAILED:
        {
            set_fail_state( "TQUERY_QUERY_FAILED" )
        }
    }
    
    if( Errcode )
    {
        set_fail_state( "ERRCODE" )
    }

    new id
    id = Data[ 0 ]
    
    if( ~IsConnected( id ) )
        return PLUGIN_HANDLED
    
    if( SQL_NumResults( Query ) < 1 )
    {
        // do something else
    }
    else
    {
        static iValue
        if( !iValue ) iValue = SQL_FieldNameToNum( Query, "player_value" )
        
        g_iPlayerValue[ id ] = SQL_ReadResult( Query, iValue )
    }

    return PLUGIN_CONTINUE
} 


but i don't know why sometimes when used method 2 (with cached value iValue) i get error:

[MySQL] Invalid column: -1
[AMXX] Run time error 10: native error (native "SQL_ReadResult")

Thanks.

[aaarnas]

Best:
SELECT player_value FROM ...

g_iPlayerValue[ id ] = SQL_ReadResult(Query, 0)

Just write all needed columns in query and then just type column number. Starts from 0.
SQL_FieldNameToNum is needed to use when using '*' for columns (All columns), and you don't know order. Or for removing hardcoding.