[kratoss1812]

Got the following table

PHP Code:

"CREATE TABLE IF NOT EXISTS `stats` (`steamid` varchar(32) PRIMARY KEY NOT NULL, `xp` INT( 16 ), `level` INT( 16 ))" 


.. somewhere in the code ..

PHP Code:

..
    iXP[client] = SQL_FetchInt(hndl, 0);
    iLevel[client] = SQL_FetchInt(hndl, 1);
.. 


xp is returner right, but the level no

what I did wrong?

this is stressing me out

[8guawong]

Originally Posted by kratoss1812 Got the following table PHP Code: "CREATE TABLE IF NOT EXISTS `stats` (`steamid` varchar(32) PRIMARY KEY NOT NULL, `xp` INT( 16 ), `level` INT( 16 ))"  .. somewhere in the code .. PHP Code: ..     iXP[client] = SQL_FetchInt(hndl, 0);     iLevel[client] = SQL_FetchInt(hndl, 1); ..  xp is returner right, but the level no what I did wrong? this is stressing me out

you didn't show your mysql query....

[Ilusion9]

You need to do a select query:

PHP Code:

select xp, level from stats where steamid = %d 


Then in the thread function you fetch the row and then you fetch the columns:

PHP Code:


if (rs.FetchRow())
{
    int xp = rs.FetchInt(0); // the first column
    int level = rs.FetchInt(1); // the second column
} 


[kratoss1812]

Figured out literally 2 seconds after I posted this. My dumbass was selecting only the xp..

Thanks