MySQL BlueGR38
#2

Link it in a command ,
ex: cmd:top5
and link it
PHP код:
mysql_query("SELECT username, score FROM `table` ORDER BY `score` DESC LIMIT 5");
mysql_store_result(); 
new 
numtop[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]); 
Good luck
Reply


Messages In This Thread
MySQL BlueGR38 - by Mriss - 05.04.2014, 22:07
Re : MySQL BlueGR38 - by MCZOFT - 05.04.2014, 22:19
Re: MySQL BlueGR38 - by Mriss - 05.04.2014, 22:23
Re: MySQL BlueGR38 - by Mriss - 05.04.2014, 22:25
Re: MySQL BlueGR38 - by Mriss - 06.04.2014, 04:28
Re: MySQL BlueGR38 - by VishvaJeet - 06.04.2014, 06:40
Re: MySQL BlueGR38 - by Dubya - 06.04.2014, 07:14

Forum Jump:


Users browsing this thread: 3 Guest(s)