Untitled

<? 
require('connect.php');
require('setting.php');

$query_rat = "SELECT *, Pos AS POS, fg AS FG, 3p AS 3P , ft AS FT, rng AS RNG, exp AS EXP, dnk  AS DNK, blk AS BLK, stl AS STL, orb AS ORB, drb AS DRB, ovr AS OVR FROM nba WHERE team='Free Agents' ORDER BY $sort DESC";
$rat = mysql_query($query_rat, $db) or die(mysql_error());
$row_rat = mysql_fetch_assoc($rat);
$totalRows_rat = mysql_num_rows($rat);

?>

<title>Free Agents</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="../skins/powder/styles.css" rel="stylesheet" type="text/css" />
</head>
<body bgcolor="#ba8852" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<center>

<table width="710" border="0" cellpadding="0" cellspacing="0" style="border-style: solid; border-width: thin; border-color:#666666;">
  <tr>
    <td colspan="14" background="../images/buttons/bgmen.jpg" bgcolor="#819AAD"><img src="../images/buttons/freeag.jpg" width="113" height="17"></td>
  </tr>
  <tr bgcolor="#b99d79">
    <td width="33">#</td>
    <td>Player</td>
    <td width="33"><a href="fas.php?sort=EXP">EXP</a></td>
    <td width="33"><a href="fas.php?sort=POS">Pos</a></td>
    <td width="33"><a href="fas.php?sort=FG">FG</a></td>
    <td width="33"><a href="fas.php?sort=3P">3P</a></td>
    <td width="33"><a href="fas.php?sort=FT">FT</a></td>
    <td width="33"><a href="fas.php?sort=RNG">RNG</a></td>
    <td width="33"><a href="fas.php?sort=DNK">DNK</a></td>
    <td width="33"><a href="fas.php?sort=BLK">BLK</a></td>
    <td width="33"><a href="fas.php?sort=STL">STL</a></td>
    <td width="33"><a href="fas.php?sort=ORB">ORB</a></td>
    <td width="33"><a href="fas.php?sort=DRB">DRB</a></td>
    <td width="33"><a href="fas.php?sort=OVR">Ovr</a></td>
  </tr>
  <?php do { { 
        $bgcolor = (++$i & 1) ? '#ba8852' : '#858276';
        echo "<tr bgcolor='$bgcolor'>\n";
}?>
  <tr bgcolor="<? print $bgcolor ?>">
    <td width="33"><?php echo $row_rat['num']; ?></td>
    <td><a href="<?PHP echo "fasp.php?name=" . $row_rat['name'] .""; ?>"><?php echo $row_rat['fname']; ?> <?php echo $row_rat['lname']; ?></a></td>
    <td width="33"><?php echo $row_rat['exp']; ?></td>
    <td width="33"><?php echo $row_rat['Pos']; ?></td>
    <td width="33"><?php echo $row_rat['fg']; ?></td>
    <td width="33"><?php echo $row_rat['3p']; ?></td>
    <td width="33"><?php echo $row_rat['ft']; ?></td>
    <td width="33"><?php echo $row_rat['rng']; ?></td>
    <td width="33"><?php echo $row_rat['dnk']; ?></td>
    <td width="33"><?php echo $row_rat['blk']; ?></td>
    <td width="33"><?php echo $row_rat['stl']; ?></td>
    <td width="33"><?php echo $row_rat['orb']; ?></td>
    <td width="33"><?php echo $row_rat['drb']; ?></td>
    <td width="33"><?php echo $row_rat['ovr']; ?></td>
    <?php } while ($row_rat = mysql_fetch_assoc($rat)); ?>
  </tr>
</table>
</center>
</body>
</html>