"; include 'dbc.php'; $vw = " Potential Free Agents "; print " These players are projected to become free agents next season.

NOTE: The age of Unrestricted Free Agency has lowered from 31 to 28.

Unrestricted Free Agents

"; $i = 1; $NoStats = ""; $query = "SELECT * FROM Players WHERE ((Level = 1 OR Level = 2 OR Level = -1) AND Age > 26 AND Contract = 1) OR (Age > 26 AND Level = 0) OR (Age > 18 AND Age < 27 AND Contract = 0 AND (Level = 1 OR Level = 2 OR Level = -1)) ORDER BY LastName"; $result = mysql_query ($query, $connection); print ""; while ($row = @mysql_fetch_array ($result)) { $PlayerID = $row["PlayerID"]; $SkillClass = $row["SkillClass"]; $Team = $row["Team"]; $City = "Free Agent"; $MarqueeSymbol = ' '; $BigStars = 2; include 'PlayerSkillClass.php'; $query99 = "SELECT * FROM FreeAgency WHERE PlayerID = $PlayerID"; $result99 = mysql_query ($query99, $connection); $row99 = mysql_fetch_array ($result99); if (($row99["AgentType"] == 2)||($row99["AgentType"] == NULL)) { $query = "SELECT * FROM Teams WHERE TeamNum = $Team"; $teams = mysql_query ($query, $connection); while ($getteams = mysql_fetch_array($teams)) { $City = $getteams["City"]; $Club = $getteams["Club"]; } print ""; } } print "

Name	Pos	Hand	Age	Last Contract	Team
" . $vw . $PlayerID . ">" . $row["FirstName"] . " " . $row["LastName"] . "".$MarqueeSymbol."	" . $row["Position"] . "	" . $row["Hand"] . "	" . $row["Age"] . "	$" . $row["LastSalary"] . "/" . $row["LastContract"] . "	" . $City . "

"; print "
"; print "Restricted Free Agents

"; // OR (Age < 27 AND Level = 0) // $query = "SELECT * FROM Players WHERE ((Level = 1 OR Level = 2 OR Level = -1) AND Age > 26 AND Contract = 1) OR (Age > 26 AND Level = 0) OR (Age > 18 AND Age < 27 AND Contract = 0) ORDER BY LastName"; $query = "SELECT * FROM Players WHERE ((Level = 1 OR Level = 2 OR Level = -1) AND Age < 27 AND Contract = 1) OR (Age < 27 AND Level = 0) OR (Age > 18 AND Age < 27 AND Contract = 0 AND (Level = 1 OR Level = 2 OR Level = -1)) ORDER BY LastName"; $result = mysql_query ($query, $connection); print ""; while ($row = @mysql_fetch_array ($result)) { $PlayerID = $row["PlayerID"]; $SkillClass = $row["SkillClass"]; $Team = $row["Team"]; $City = "Free Agent"; $MarqueeSymbol = ' '; $BigStars = 2; include 'PlayerSkillClass.php'; $query99 = "SELECT * FROM FreeAgency WHERE PlayerID = $PlayerID"; $result99 = mysql_query ($query99, $connection); $row99 = mysql_fetch_array ($result99); if (($row99["AgentType"] == 1)||($row99["AgentType"] == NULL)) { $query = "SELECT * FROM Teams WHERE TeamNum = $Team"; $teams = mysql_query ($query, $connection); while ($getteams = mysql_fetch_array($teams)) { $City = $getteams["City"]; $Club = $getteams["Club"]; } print ""; } } print "

Name	Pos	Hand	Age	Last Contract	Team
" . $vw . $PlayerID . ">" . $row["FirstName"] . " " . $row["LastName"] . "".$MarqueeSymbol."	" . $row["Position"] . "	" . $row["Hand"] . "	" . $row["Age"] . "	$" . $row["LastSalary"] . "/" . $row["LastContract"] . "	" . $City . "

"; ?>