// ?>
NFL Football Regular Season Game Scores
$currentyear Season Week $week:";
echo "";
//then we determine how what the game days are
$gamedaysquery = "select distinct SUBSTRING(gametime, 1, 8) as firstpart from scores where year = '$currentyear' and week = '$week' order by firstpart asc";
$gamedaysquery2 = mysql_query($gamedaysquery) or die(mysql_error());
while ($gamedaysquery3 = mysql_fetch_array($gamedaysquery2)) {
$gameday = $gamedaysquery3['firstpart'];
//convert $gameday to actual day of the week
$gameday_display = date("F jS", strtotime("$gameday"));
echo "";
} // end of games lookup
} //end of
echo "";
} //end of week loop
?>
Played: $gameday_display
";
//then we grab the individual game info
$gamequery = "select * from scores where year = '$currentyear' and week = '$week' and gametime like '$gameday%'order by CAST(gameid AS UNSIGNED), gameid asc";
$gamequery2 = mysql_query($gamequery);
while ($gamequery3 = mysql_fetch_array($gamequery2)) {
$hometeam = $gamequery3['hometeam'];
$visitingteam = $gamequery3['visitingteam'];
$gameid = $gamequery3['gameid'];
$hometeamscore = $gamequery3['hometeamscore'];
$visitingteamscore = $gamequery3['visitingteamscore'];
echo "";
if ($hometeamscore) { echo " ($hometeamscore) "; }
echo "$hometeam 
";
echo "
";
echo " @ 
$visitingteam";
if ($visitingteamscore) { echo " ($visitingteamscore) "; }
echo "
$visitingteam";
if ($visitingteamscore) { echo " ($visitingteamscore) "; }
echo "