Friday, October 23rd, 2020
// ?>
NFL Football Regular Season Game Schedules
Week $week:
"; //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 "
$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']; echo "
$hometeam vs $visitingteam
"; } // end of games lookup echo "
"; } //end of echo "[Top]
"; } //end of week loop ?>