Game Schedules

Season* Division* Category* Competition* Group
";?> "; ?> "; ?> "; ?> "; ?>
Team Sort Sequence*
"; ?>

"; $sql = "SELECT gameschedule.gameid , gameschedule.groupid , gameschedule.series , gameschedule.homeid , gameschedule.visitorid , gameschedule.date , gameschedule.location , gameschedule.starttime , gameschedule.endtime , gameschedule.status , gameschedule.comments FROM gameschedule WHERE gameschedule.categoryid = $lecategory AND gameschedule.competitionid = $lecompetition AND gameschedule.seasonid = $leseason AND gameschedule.divisionid = $ledivision AND gameschedule.groupid = $letier AND (gameschedule.homeid = $leteam OR gameschedule.visitorid = $leteam) $orderBy"; } else if (($leteam == -1)&&($letier != -1)){ //print "2
"; $sql = "SELECT gameschedule.gameid , gameschedule.groupid , gameschedule.series , gameschedule.homeid , gameschedule.visitorid , gameschedule.date , gameschedule.location , gameschedule.starttime , gameschedule.endtime , gameschedule.status , gameschedule.comments FROM gameschedule WHERE gameschedule.categoryid = $lecategory AND gameschedule.competitionid = $lecompetition AND gameschedule.seasonid = $leseason AND gameschedule.divisionid = $ledivision AND gameschedule.groupid = $letier $orderBy"; } else if (($leteam != -1)&&($letier == -1)){ //print "3
"; $sql = "SELECT gameschedule.gameid , gameschedule.groupid , gameschedule.series , gameschedule.homeid , gameschedule.visitorid , gameschedule.date , gameschedule.location , gameschedule.starttime , gameschedule.endtime , gameschedule.status , gameschedule.comments FROM gameschedule WHERE gameschedule.categoryid = $lecategory AND gameschedule.competitionid = $lecompetition AND gameschedule.seasonid = $leseason AND gameschedule.divisionid = $ledivision AND (gameschedule.homeid = $leteam OR gameschedule.visitorid = $leteam) $orderBy"; } else { //print "4
"; $sql = "SELECT gameschedule.gameid , gameschedule.groupid , gameschedule.series , gameschedule.homeid , gameschedule.visitorid , gameschedule.date , gameschedule.location , gameschedule.starttime , gameschedule.endtime , gameschedule.status , gameschedule.comments FROM gameschedule WHERE gameschedule.categoryid = $lecategory AND gameschedule.competitionid = $lecompetition AND gameschedule.seasonid = $leseason AND gameschedule.divisionid = $ledivision $orderBy"; }//end if //print "$sql
"; if($sqlcn){ $sqlresult = mysqli_query($sqlcn, $sql); if(($sqlresult == true)&&(mysqli_num_rows($sqlresult) != 0)){ $hasrecords = true; $zo = 0; }// }// ?>
There Are No Games Scheduled for this Filtered Selection
Date & Time Subject To Change Without Notice. Please Confirm With Your Team Manager.

Season: Division: Group:
Competition: Category: Date:
'') && ($sqlrow[series] != $previousSeries) && ($letier != -1)&& ($leteam == -1)){ ?>
Game ID Group Home Visitor Date Location Start Time End Time Status Remarks
"; } else { print ">"; } print (getTeamName($sqlrow["homeid"])); print "\n"; ?> "; } else { print ">"; } print (getTeamName($sqlrow["visitorid"])); print "\n"; ?>
Printing Instructions:
Page Setup (LANDSCAPE) Print Margins for Full Page Printout. Left: 0.01; Right, Top, Bottom: 0.00