[TheKidz]

PHP Code:

formatex( gCache, charsmax( gCache ),"SELECT `name` FROM `%s`.`players` WHERE (`players`.`name` = '%s')", SQL_DB, szArgs )     
SQL_ThreadQuery( SQL_Tuple, "GetName", gCache, Data, 1 ); 


Everything is right, but when i try to get those results i got error in column.

if i do like this

PHP Code:

SQL_ReadResult( Query, 0, szQueryResult, charsmax( szQueryResult ) ); 


it works with only 1 item inside the table, but when i got 2 or more i got column error. Any1 know whats the problem ? ):

[Exolent[jNr]]

Because you are getting multiple rows with 1 column.

Use SQL_MoreResults() and SQL_NextRow() to get all of the results.
Need more info? Check out the SQLx tutorial from Hawk552.

[lucas_7_94]

Do you use while( SQL_NumResults( Query ) ) ?

PS: Exolent won me 2 seconds u.u , btw , if you want any code to look , check my miniduel system.

[Exolent[jNr]]

Originally Posted by lucas_7_94 while( SQL_NumResults( Query ) )

Nice infinite loop you've got there.

[lucas_7_94]

I'm try to say sawse if he use a loop to get the data , to evite the infinite loop use SQL_NextRow( Query )

[Exolent[jNr]]

Originally Posted by lucas_7_94 I'm try to say sawse if he use a loop to get the data , to evite the infinite loop use SQL_NextRow( Query )

That won't fix your infinite loop. You have to use SQL_MoreResults().

[lucas_7_94]

oh yes , sorry , i'm confused at the names lol