[Alec24]

Quote:

Originally Posted by $ЂЯĢ It's case sensitive by default.

I meant case insensitive though? Will it find "Alec" if I type "ALEC"?

Also:

Код:

format(query, sizeof(query), "SELECT Name,PhoneNumber FROM players WHERE Name LIKE '%%%s%%'", tmp);
mysql_query(query);
mysql_store_result();
new totalResults = mysql_num_rows();
		
if(totalResults == 0)
{
	format(string,sizeof(string),"There was 0 phone numbers found for the name: '%s'.", tmp);
	SendClientMessage(playerid, COLOUR_WHITE, string);
	return 1;
}
		
format(string,sizeof(string),"There was %d phone numbers found for the name: '%s', they are listed below:", totalResults, tmp);
SendClientMessage(playerid, COLOUR_WHITE, string);
		
new ResultName[MAX_PLAYER_NAME], ResultNumber[20];
		
while(mysql_retrieve_row())
{
	mysql_fetch_field_row(ResultName, "Name");
	mysql_fetch_field_row(ResultNumber, "PhoneNumber");
		  
	if(strval(ResultNumber) > 0)
	{
		format(string,sizeof(string),"%s - %d", ResultName, strval(ResultNumber));
		SendClientMessage(playerid, COLOUR_WHITE, string);
	}
}
		
mysql_free_result();

Why does this code say it found 7 numbers but only display 2 of them?

There is no more shown.