05.04.2014, 22:19
Link it in a command ,
ex: cmd:top5
and link it
Good luck
ex: cmd:top5
and link it
PHP код:
mysql_query("SELECT username, score FROM `table` ORDER BY `score` DESC LIMIT 5");
mysql_store_result();
new num, top[5][24], score[5][5];
while(mysql_retrieve_row())
{
mysql_fetch_field_row(top[num], "username");
mysql_fetch_field_row(score[num], "score");
num++;
}
mysql_free_result();
printf("Rank 1: %s, Rank 2: %s, Rank 3: %s, Rank 4: %s, Rank 5: %s", top[0], top[1], top[2], top[3], top[4], top[5]);