require ("../controlp/inc_dbc.php"); ?>
//***********Add TEAM Table and enter nicknames and city****************
$draftyear=addslashes ("$_POST[draftyear]");//year of draft
$college=addslashes ("$_POST[college]");//College
if ("$_POST[Submit]"){
$Query3 = "SELECT * from gameinfo WHERE (decade='$draftyear') AND (pick=1) ";
echo "$draftyear";
$Result3 = mysql_db_query ($DBName, $Query3, $Link);
while ($Row3 = mysql_fetch_array ($Result3)) {
echo "
Name: $Row3[player] | Pick: $Row3[pick] | College: $Row3[college] | Picked by: $Row3[team] | Sport: $Row3[sport] ";
}
echo"
";
}//Number one by year
if ("$_POST[uteam]"){
$Query3 = "SELECT * from gameinfo WHERE (college='$college') AND (pick=1) ";
echo "$draftyear";
$Result3 = mysql_db_query ($DBName, $Query3, $Link);
while ($Row3 = mysql_fetch_array ($Result3)) {
echo "
Name: $Row3[player] | Pick: $Row3[pick] | College: $Row3[college] | Picked by: $Row3[team] | Sport: $Row3[sport] ";
}
echo"
";
}//Number one by year
?>
Related Games: Name that College | The Draft Pick Game