\n
![](\"$aim_file\") | \n
$number | \n
$fname $lname | \n
$b-$t | \n
$height | \n
$weight | \n
$acquired | \n
\n";
}
?>
|
\n
| \n
$number | \n
$fname $lname | \n
$b-$t | \n
$height | \n
$weight | \n
$acquired | \n
\n";
}
?>
|
\n
| \n
$number | \n
$fname $lname | \n
$b-$t | \n
$height | \n
$weight | \n
$acquired | \n
\n";
}
?>
|
\n
| \n
$number | \n
$fname $lname | \n
$b-$t | \n
$height | \n
$weight | \n
$acquired | \n
\n";
}
?>
|
\n
| \n
$number | \n
$fname $lname | \n
$b-$t | \n
$height | \n
$weight | \n
$acquired | \n
\n";
}
?>
|
\n
![\"15-Day](\"93-dh.gif\")
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n";
$SQL = "SELECT pnum, lname, fname, number, b, t, height, weight, SUBSTRING_INDEX(acquired, ' ', 16) AS acquired FROM players WHERE (pos = '11') && cur_team = '$cur_team' && (dl_length = '' || dl_length = 'DT') ORDER by lname, fname ASC";
$result = mysql_query($SQL) or die("could not complete your query 27");
while($row = mysql_fetch_array($result)) {
$pnum = $row["pnum"];
$aim = strtolower($row["lname"]) . "_" . strtolower($row["fname"]);
$aim_file = "aim/" . $aim . ".gif";
if (!file_exists($aim_file))
$aim_file = "aim/" . $cur_team . ".gif";
$number = $row["number"];
$lname = $row["lname"];
$fname = $row["fname"];
$b = $row["b"];
if ($b == "B")
$b = "S";
$t = $row["t"];
$height = $row["height"];
$weight = $row["weight"];
$acquired = $row["acquired"];
if ($acquired != "")
$acquired .= "...";
echo " \n
| \n
$number | \n
$fname $lname | \n
$b-$t | \n
$height | \n
$weight | \n
$acquired | \n
\n";
}
}
if ($cur_team == "det")
{
echo " ";
}
?>
\n
| ![\"15-Day](\"93-15day.gif\")
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n";
$SQL = "SELECT pnum, lname, fname, number, b, t, height, weight, SUBSTRING_INDEX(acquired, ' ', 16) AS acquired FROM players WHERE dl_length = '15' && cur_team = '$cur_team' ORDER by lname, fname ASC";
$result = mysql_query($SQL) or die("could not complete your query 27");
while($row = mysql_fetch_array($result)) {
$pnum = $row["pnum"];
$aim = strtolower($row["lname"]) . "_" . strtolower($row["fname"]);
$aim_file = "aim/" . $aim . ".gif";
if (!file_exists($aim_file))
$aim_file = "aim/" . $cur_team . ".gif";
$number = $row["number"];
$lname = $row["lname"];
$fname = $row["fname"];
$b = $row["b"];
if ($b == "B")
$b = "S";
$t = $row["t"];
$height = $row["height"];
$weight = $row["weight"];
$acquired = $row["acquired"];
if ($acquired != "")
$acquired .= "...";
echo " \n
| \n
$number | \n
$fname $lname | \n
$b-$t | \n
$height | \n
$weight | \n
$acquired | \n
\n";
}
if ($result == "")
{
echo " \n
| \n
No Players | \n
$b-$t | \n
\n";
}
}
if ($cur_team == "det")
{
echo " ";
}
?> \n
| ![\"60-Day](\"93-60day.gif\")
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n";
$SQL = "SELECT pnum, lname, fname, number, b, t, height, weight, SUBSTRING_INDEX(acquired, ' ', 16) AS acquired FROM players WHERE dl_length = '60' && cur_team = '$cur_team' ORDER by lname, fname ASC";
$result = mysql_query($SQL) or die("could not complete your query 27");
while($row = mysql_fetch_array($result)) {
$pnum = $row["pnum"];
$aim = strtolower($row["lname"]) . "_" . strtolower($row["fname"]);
$aim_file = "aim/" . $aim . ".gif";
if (!file_exists($aim_file))
$aim_file = "aim/" . $cur_team . ".gif";
$number = $row["number"];
$lname = $row["lname"];
$fname = $row["fname"];
$b = $row["b"];
if ($b == "B")
$b = "S";
$t = $row["t"];
$height = $row["height"];
$weight = $row["weight"];
$acquired = $row["acquired"];
if ($acquired != "")
$acquired .= "...";
echo " \n
| \n
$number | \n
$fname $lname | \n
$b-$t | \n
$height | \n
$weight | \n
$acquired | \n
\n";
}
if ($result == "")
{
echo " \n
| \n
No Players | \n
$b-$t | \n
\n";
}
}
if ($cur_team == "det")
{
echo " ";
}
?> \n
| ![\"40-Man](\"93-40man.gif\")
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
";
$SQL = "SELECT pnum, lname, fname, stnumber, b, t, height, weight, SUBSTRING_INDEX(acquired, ' ', 16) AS acquired FROM players WHERE 40man = 'Y' ORDER by lname, fname ASC";
$result = mysql_query($SQL) or die("could not complete your query 27");
while($row = mysql_fetch_array($result)) {
$pnum = $row["pnum"];
$aim = strtolower($row["lname"]) . "_" . strtolower($row["fname"]);
$aim_file = "aim/" . $aim . ".gif";
if (!file_exists($aim_file))
$aim_file = "aim/" . $cur_team . ".gif";
$stnumber = $row["stnumber"];
$lname = $row["lname"];
$fname = $row["fname"];
$b = $row["b"];
if ($b == "B")
$b = "S";
$t = $row["t"];
$height = $row["height"];
$weight = $row["weight"];
$acquired = $row["acquired"];
if ($acquired != "")
$acquired .= "...";
echo " \n
| \n
$stnumber | \n
$fname $lname | \n
$b-$t | \n
$height | \n
$weight | \n
$acquired | \n
\n";
}
}
if ($cur_team == "det")
{
echo " ";
}
?>\n
| ![\"Non-Roster](\"93-nonroster.gif\")
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n";
$SQL = "SELECT pnum, lname, fname, stnumber, b, t, height, weight, SUBSTRING_INDEX(acquired, ' ', 16) AS acquired FROM players WHERE st = 'Y' ORDER by lname, fname ASC";
$result = mysql_query($SQL) or die("could not complete your query 27");
while($row = mysql_fetch_array($result)) {
$pnum = $row["pnum"];
$aim = strtolower($row["lname"]) . "_" . strtolower($row["fname"]);
$aim_file = "aim/" . $aim . ".gif";
if (!file_exists($aim_file))
$aim_file = "aim/" . $cur_team . ".gif";
$stnumber = $row["stnumber"];
$lname = $row["lname"];
$fname = $row["fname"];
$b = $row["b"];
if ($b == "B")
$b = "S";
$t = $row["t"];
$height = $row["height"];
$weight = $row["weight"];
$acquired = $row["acquired"];
if ($acquired != "")
$acquired .= "...";
echo " \n
| \n
$stnumber | \n
$fname $lname | \n
$b-$t | \n
$height | \n
$weight | \n
$acquired | \n
\n";
}
if ($result == "")
{
echo " \n
| \n
No Players | \n
$b-$t | \n
\n";
}
}
if ($cur_team == "det")
{
echo " ";
}
?>
|