Next Games
Posted: Thu Jan 25, 2018 9:33 pm
I'm having an issue with the Next Games line in the pro and farm team headers.
http://www.nsimhl.com/ProTeam.php?Team=3
Below is code from ProTeam.php. I changed the "ORDER BY GameNumber LIMIT 1" to "ORDER BY Play LIMIT 1" for the next game.
$Query = "SELECT * FROM SchedulePro WHERE (VisitorTeam = " . $Team . " OR HomeTeam = " . $Team . ") ORDER BY Play LIMIT 1";
$ScheduleNext = $db->querySingle($Query,true);
In my tests everything works out just fine. When I uploaded today, it appears to only be showing the team's next road game.
I need help!
http://www.nsimhl.com/ProTeam.php?Team=3
Below is code from ProTeam.php. I changed the "ORDER BY GameNumber LIMIT 1" to "ORDER BY Play LIMIT 1" for the next game.
$Query = "SELECT * FROM SchedulePro WHERE (VisitorTeam = " . $Team . " OR HomeTeam = " . $Team . ") ORDER BY Play LIMIT 1";
$ScheduleNext = $db->querySingle($Query,true);
In my tests everything works out just fine. When I uploaded today, it appears to only be showing the team's next road game.
I need help!