[SOLVED] Player ranking system

[timmah1]

Does anybody know where I can find a tutorial or if somebody knows how to make a ranking system?

 

I'm trying to make a ranking system and show the top 20 players, and if you're not in the top 20, it shows your rank below the top 20.

I can't figure out how to make one, and I can't find a tutorial or anything for user ranking, only page ranking.

 

Any help would be appreciated.

 

Thanks in advance.

[ober]

What kind of ranking are you referring to?  What values are you storing?

[timmah1]

Player Rankings. The top 20 players of the game.

 

I'm storing values of money.

It's an online game, and the person with the most money should be on top obviously, and so forth down to 20.

 

If your ranking isn't in the top 20, it should still show your ranking, but below the top 20.

[ober]

SELECT * FROM players ORDER BY money DESC

[timmah1]

I am currently doing that

 

$worth="SELECT * FROM profile WHERE tour = '$tour_name' ORDER BY worth DESC LIMIT 20";

 

But I need to show the ranking(1,2,3, etc...) beside the players name, and I cannot figure out how to do that

[DarkWater]

Just make an incrementing variable that you output inside the while loop:

 

$count = 1;

while ($row = mysql_fetch_assoc($result)) {

  echo "$count: {$row['name']}";

  $count++;

}

 

Something like that.

[ober]

Just add a counter variable to the while loop:

 

$i = 1;
while($row = mysql_fetch_array($result))
{
    echo $i . " " . $blah;
    $i++;
}

[timmah1]

I'm using this

 

$i = 1;
while($r=mysql_fetch_assoc($result)){
echo $i . " " . $r['username'];
$i++;
}

but it doesn't produce any number beside the username

[timmah1]

nevermind, I just realized i had this twice

 

while($r=mysql_fetch_assoc($result)){

 

after deleting one of them, it works perfect now

 

Thanks