Here is the list of the best Crash! scores on ".$_GET['level']." & ".$_GET['nr'].""; echo "".$_GET['event'].""; $i = 1; $rank = 0; $preValue = 0; $sql = 'SELECT 0 + REPLACE(a.value, \',\', \'\') AS score, a.uid FROM `profile_values` a' . ' LEFT JOIN `profile_fields` b ON (a.fid = b.fid) WHERE ' . ' b.name = \'%s\' AND' . ' (a.value is not null AND a.value != \'\') AND 0+REPLACE(a.value, \',\', \'\') > 0' . ' ORDER BY score DESC ' . ' LIMIT 0, 300'; $result = db_query($sql, $_GET['lboard']); echo " Rank Name Score "; while($row = mysql_fetch_array($result)) { $profile = user_load(array('uid' => $row['uid'])); if($prevalue != $row['score']) $rank = $i; $prevalue = $row['score']; if($rank==1) echo ""; else echo ""; echo "" . $rank . ""; echo "" . $profile->name . ""; echo "".$row['score'].""; echo ""; $i = $i + 1; } echo ""; ?>