03.08.2011, 10:18
pawn Code:
mysql_query("SELECT `username` FROM `table` ORDER BY `score` DESC LIMIT 10");
mysql_store_result();
new num;
new top[10][24];
while(mysql_retrieve_row())
{
mysql_fetch_field_row(top[num], "username");
num++;
}
mysql_free_result();
printf("Rank 1: %s, Rank 2: %s, Rank 3: %s, Rank 4: %s, Rank 5: %s, Rank 6: %s, Rank 7: %s, Rank 8: %s, Rank 9: %s, Rank 10: %s", top[0], top[1], top[2], top[3], top[4], top[5], top[6], top[7], top[8], top[9]);