Saturday, September 23rd, 2023
// ?>
";
//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 "
"; } //end of echo "[Top]
"; } //end of week loop ?>
"; //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 echo "[Top]
"; } //end of week loop ?>