I have a function that works on other pages but on this particular page its not working 100%

the piece of code that is failing to work is:

    $query = "SELECT 
            * 
            FROM 
            rank_punting
            JOIN
            rank_player
            ON
            rank_player.full_name=rank_punting.name
            WHERE 
            active='1'
            AND 
            class='$class'
            ORDER BY ABS(`rank_punting`.`rank_final`) ASC";
    $rank = 0;  $lastpct = 0;
$db->setQuery($query);
                        $result = $db->query();

        if(mysql_num_rows($result) > 0) 
        {
            while($row = mysql_fetch_array($result, MYSQL_ASSOC))
            {
                    if ($row['rank_final'] > $lastpct) {
                   $rank++;
                   $lastpct = $row['rank_final'];
               }
                        $name = $row['name'];
                        $s1= $row['s1'];
                        $s2= $row['s2'];
                        $s3= $row['s3'];
                        $s4= $row['s4'];
                        $s5= $row['s5'];
                        $s6= $row['s6'];
                        $s7= $row['s7'];
                        $s8= $row['s8'];
                        $s9= $row['s9'];
                        $c1= $row['c1'];
                        $c2= $row['c2'];
                        $c3= $row['c3'];
                        $c4= $row['c4'];
                        $c5= $row['c5'];
                        $c6= $row['c6'];
                        $v1= $row['v1'];
                        $v2= $row['v2'];
                        $comp= $row['comp_rank_final'];
                        $season= $row['season_rank_final'];
                        $final=$row['rank_final'];





                        $link = "website_url";


                        $link2 = "<a href=\"http://{$link}\"  target='_blank'>{$name}<br>Profile Page</a>";

                        if ($link = ''){$link2 = "<a href='index.php?option=com_ranking&view=playerprofile&player={$name}' >{$name}<br>Profile Page</a>";}






                        echo '<tr>';
                        echo "  <th scope'row'>{$link2} {$lastpct} </th>";
                        echo "<td>";  echo 'DEBUG: ';  echo $row['rank_final']; echo $lastpct;echo "{$rank}</td>";
                        echo "<td> Competition</td>";
                        echo "<td> {$comp}</td>";
                        echo "<td> {$c1}</td>";
                        echo "<td> {$c2}</td>";
                        echo "<td> {$c3}</td>";
                        echo "<td> {$c4}</td>";
                        echo "<td> {$c5}</td>";
                        echo "<td> {$c6}</td>";
                        echo "<td> {$c7}</td>";
                        echo "<td> {$c8}</td>";
                        echo "<td> {$v2}</td>";

                        echo "</tr>";
                        echo '<tr>';
                        echo "<th scope'row'> </th>";  echo "<td>  </td>";
                        echo "<td> Game Film</td>";
                        echo "<td> {$season}</td>";
                        echo "<td> {$s1}</td>";
                        echo "<td> {$s2}</td>";
                        echo "<td> {$s3}</td>";
                        echo "<td> {$s4}</td>";
                        echo "<td> {$s5}</td>";
                        echo "<td> {$s7}</td>";
                        echo "<td> {$s8}</td>";
                        echo "<td> {$s6}</td>";
                        echo "<td> {$v1}</td>";
                        echo "</tr>";

        }


        }

//----------------

echo '</tbody>


</table>';


}