Mysql LeaderBoard
#5

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]);
Think that's right, it's late and I'm pretty tired. Replace those field names with yours .
Reply


Messages In This Thread
Mysql LeaderBoard - by Lefon - 03.08.2011, 10:05
Re: Mysql LeaderBoard - by Vince - 03.08.2011, 10:14
Re: Mysql LeaderBoard - by Lefon - 03.08.2011, 10:16
Re: Mysql LeaderBoard - by GangsTa_ - 03.08.2011, 10:17
Re: Mysql LeaderBoard - by [HiC]TheKiller - 03.08.2011, 10:18
Re: Mysql LeaderBoard - by Lefon - 03.08.2011, 10:33
Re: Mysql LeaderBoard - by [HiC]TheKiller - 04.08.2011, 06:42

Forum Jump:


Users browsing this thread: 3 Guest(s)