[Nils94]

Solved.

[Konstantinos]

I'll assume the field for the name is 1. Just be sure you use LIMIT 3 in the query so it won't exceed in temp_Name array.

pawn Code:

new rows = cache_num_rows(), string[100], temp_Name[3][MAX_PLAYER_NAME] = {"N/A", "N/A", "N/A"};
for (new j; j != rows; ++j) cache_get_row(j, 1, temp_Name[j]);
format(string, sizeof (string), "\n\n\n\nP 1: %s\nP 2: %s\nP 3: %s", temp_Name[0], temp_Name[1], temp_Name[2]);