[SOLVED] Calculate Rank

[sandrob57]

I need to display the rank of my players.

 

The rank is based on this row: c_strength

 

What would I use to count their rank, ie:

 

Rank: 54 of 5,231

[Barand]

<?php

$sql = "SELECT COUNT(*) FROM players";
$res = mysql_query($sql)
$total_players = mysql_result($res, 0);


//for a particular player identified by $player_id

$sql = "SELECT COUNT(*) FROM players 
         WHERE c_strength > 
         (SELECT c_strength FROM players WHERE player_id = '$player_id');
$res = mysql_query($sql)
$rank = mysql_result($res, 0) + 1;

echo "Rank: $rank of $total_players";
?>

 

 

 

[sandrob57]

Never mind, i got it to work. Thanks so much!