Well 1st your problem is,
1) your variable is integer
2) your reading datanum as you read "integer"
3) your outputing your variable as integer aswell
but you should be doing as string
PHP Code:
public SelectHandle(FailState,Handle:Query,Error[],Errcode,Data[],DataSize)
{
if(FailState == TQUERY_CONNECT_FAILED)
return set_fail_state("Could not connect to SQL database.")
else if(FailState == TQUERY_QUERY_FAILED)
return set_fail_state("Query failed.")
if(Errcode)
return log_amx("Error on query: %s",Error)
new DataNum[32]
while(SQL_MoreResults(Query))
{
SQL_ReadResult(Query, 0, DataNum, 31)
ColorChat(0, NORMAL, "%s", DataNum)
SQL_NextRow(Query)
}
return PLUGIN_CONTINUE
}
this should work