I wan't to add the function of my script below to show at which position $username is..

<?php
$database->setQuery("SELECT member_earned, member_spent, member_adjustment FROM mcdkp_members WHERE member_name='$username'");
$dbArray = $database->loadAssocList();
$dbArray = $dbArray[0];
$total_dkp = $dbArray['member_earned']-$dbArray['member_spent']+$dbArray['member_adjustment'];
$total_dkp = number_format($total_dkp, 2, '.', '');
echo "MC: ";
if ($total_dkp < 0) {
echo "<font color=\"red\">$total_dkp</font>";
}
if ($total_dkp > 0) {
echo "<font color=\"green\">$total_dkp</font>";
}
if ($total_dkp = 0) {
echo "<font color=\"white\">$total_dkp</font>";
}
?>

soo.. it would be something like.. get class_id from $username, do the above calculations on all the users in class_id=x and sort them descending.. 
return position of $username and echo "Your rank is:X ";

A sorted example is shown here -> http://www.fc-guild.org/mc_dkp/listmembers.php?o=4.0&filter=Hunter

Where i Thumann would be rank 3.


user tables are here: 
http://www.fc-guild.org/images/hunters.jpg

Only one question remains.. how is it done code-wise?