[Exceed]

I get the error message, "no such table: User_info" as i am connection to my database.

I have a table called User_info with 2 rows in it.

This is the first time i am trying to use sqlx and i have no idea if i am doing it right (i have very little experience with small).

PHP Code:

public LoadData(id)
{
    new AuthID[32], PlayerXP[32], PlayerLevel[32], PlayerClass[33], PlayerMoney[32], PlayerKills[32], PlayerDeath[32]
    get_user_authid(id,AuthID,31)
    
    new error[128], ErrorCode
    
    new Handle:info = SQL_MakeDbTuple(sqlHost,sqlUser,sqlPass,sqlDB)
    new Handle:sql = SQL_Connect(g_SqlTuple,ErrorCode,g_Error,511)
    
    new Handle:Query = SQL_PrepareQuery(sql,"SELECT %s,%s,%s,%s,%s FROM %s WHERE %s='%s'",sqlMoney,sqlKills,sqlDeaths,sqlExp,sqlLevel,sqlTable,sqlAuthid,AuthID)
    
    if (!SQL_Execute(Query))
    {
        SQL_QueryError(Query, error, 127)
        server_print("[AMXX] Could not connect to SQL database. Error: %s", error)
    } else {
    
        PlayerMoney[id] = SQL_FieldNameToNum(Query, sqlMoney)
        PlayerKills[id] = SQL_FieldNameToNum(Query, sqlKills)
        PlayerDeath[id]  = SQL_FieldNameToNum(Query, sqlDeaths)
        PlayerXP[id]  = SQL_FieldNameToNum(Query, sqlExp)
        PlayerLevel[id] = SQL_FieldNameToNum(Query, sqlLevel)
}
        SQL_FreeHandle(Query)
        SQL_FreeHandle(sql)
        SQL_FreeHandle(info)

    return PLUGIN_CONTINUE
} 


Thankyou for your time.

[Hawk552]

It's probably the wrong database; make it print out sqlDB.

[Exceed]

PHP Code:

server_print("sqlHost: %s. sqlUser: %s. sqlPass: %s. sqlDB: %s. sqlTable: %s.", sqlHost,sqlUser,sqlPass,sqlDB,sqlTable) 


returns:
sqlHost: mysql.keep-gaming.com.
sqlUser: keep_gaming_com.
sqlPass: [Censored].
sqlDB: keep_gaming_com_db.
sqlTable: User_info.

Which is exactly what is should.