// ?>

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 "
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 "
    @     $visitingteam"; if ($visitingteamscore) { echo " ($visitingteamscore) "; } echo "
"; } // end of games lookup } //end of echo "
"; } //end of week loop ?>