Drupal 6 Custom Code Fix

I need a Drupal 6 code fixed ASAP.

The basics behind the custom code are finding a score for a player based off of their fitness test results.

I believe that the problem comes with finding the rank of players in a function (below)

function rankByCriteria($criteria,$uid,$userCriteria,$allnid,$order)

{

$i=1;

$rank=0;

if($userCriteria=='0.00' || $userCriteria=='NULL')

{

$rank=0;

}

else

{

$allTestNids=implode(',',$allnid);

$criteriaRankQry=mysql_query("select * from content_type_test where nid in($allTestNids) and $criteria!='NULL' and $criteria!='0.00' order by $criteria $order")or die('rank by criteria issue');

while($criteriaRankRow=mysql_fetch_array($criteriaRankQry))

{

if($criteriaRankRow['field_player_uid']==$uid and $criteriaRankRow[$criteria]==$userCriteria)

{

$rank=$i;

}

$i++;

}

}

return $rank;

}

Here is what the function is supposed to do

1) Search a table in the database for all records that have the same training_camp_nid, are not empty and are not 0.00

2) Sort the data based on a specified criteria ($criteria) and order ($order)

3) Find the rank of a specific test result based on the current logged in user's ID.

Right now it is not finding this rank correctly. For example a player has a speed result that should rank him 13th but it is ranking him 23rd which is the total amount results found.

Need this fixed right away I have attached the actual file so you can look at it. I am available at all hours to chat. If you feel that he code needs to be completely re-written that is fine I just want it done right and fast.

Drupal MySQL PHP

Project ID: #5078600

About the project