[Dragokas]

Hi,

it is example from docs:

PHP Code:

DBStatement hUserStmt = null;
int GetSomeInfo(Database db, const char[] name)
{
    /* Check if we haven't already created the statement */
    if (hUserStmt == null)
    {
        char error[255];
        hUserStmt = SQL_PrepareQuery(db, "SELECT userid FROM vb_user WHERE username = ?", error, sizeof(error));
        if (hUserStmt == null)
        {
            return 0;
        }
    }
 
    SQL_BindParamString(hUserStmt, 0, name, false);
    if (!SQL_Execute(hUserStmt))
    {
        return 0;
    }
 
    /* Get some info here */
    /* return info; */
} 


However, it missing part "Get some info".
What function should I use here and on which handle to retrieve the results?

[Dragokas]

Well, solved:

PHP Code:

if( SQL_FetchRow(hUserStmt) )
    {
        SQL_FetchInt(hUserStmt, 0, userid);
    }