[jonatat]

I need take out username from mysql my this:

PHP Code:

new data_username = SQL_FieldNameToNum(hQuery, "username");
pUsername[id] = SQL_ReadResult(hQuery, data_username); 


formatex menu:

PHP Code:

formatex(usernamecheck, charsmax(usernamecheck), "Player: %s", pUsername[pevPlayer]); 


But i'm getting only 0 or 1, but not username. Why?

Example: Should be "NickNAme1". Getting: "0"

[Airkish]

PHP Code:

 pUsername[33][32] 


You don't need fieldnametonum

Do this:

PHP Code:

 SQL_ReadResult(hQuery, 1, pUsername[id], 32); // change 1 to your column number (starting from 0) 


[Natsheh]

PHP Code:

SQL_ReadResult(hQuery, data_username,   pUsername[id], charsmax( pUsername[]) ); 


[jonatat]

Originally Posted by Natsheh PHP Code: SQL_ReadResult(hQuery, data_username,   pUsername[id], charsmax( pUsername[]) );

Hm... Don't get anything with this

[Natsheh]

Originally Posted by jonatat Hm... Don't get anything with this

Well depends on when you are using it, am i suppose to know why with the given code?