[MoT3rror]

When I made a ranking system for a ladder system, I used this code.

PHP Code:

$rank = 0 + ($perpage * $pagenumber);
while($clans = $db->query_read($clan_query))
{
$rank++; 
// ...
} 


I found this was the easiest way to keep a update ranking system without storing it in the database and updating every hour, day, etc.

Then when I wanted to get it for a individual clan, I used this code

PHP Code:

$rankcount = $db->query_first("SELECT COUNT(column) AS 'count' FROM clans WHERE exp > $clanexp");

$rank = $rankcount['count']++;