Broome County Soccer Association

Master Schedule

This is the "official" schedule of the BCSA Fall League.
All schedule formats are kept current with all changes.

The full Master Schedule is available with the following formats:

EXCEL

WEB PAGE

Without having to download the schedule, you can select the schedule view based on the following parameters:

conn(); $club=""; if ($_SERVER["REQUEST_METHOD"] == "POST") { $club=$_POST['club']; $ageg=$_POST['ageg']; $div=$_POST['div']; $teamInfo=$_POST['team']; if (isset($teamInfo) & strlen($teamInfo)>0 ) { list($club,$ageg, $div, $team) = explode(".", $teamInfo); } } else { $club=isset($_GET['club']) ? $_GET['club'] : ""; $ageg=isset($_GET['ageg']) ? $_GET['ageg'] : ""; $div=isset($_GET['div']) ? $_GET['div'] : ""; } echo " "; echo "

"; // get the club names -- first list box //$sqlStmt = "SELECT clubs.*, teams.club FROM clubs INNER JOIN teams ON clubs.symbol=teams.club "; $sqlStmt1 = "SELECT DISTINCT club FROM ".$teamsDbTable." ORDER BY club"; $result1 = $db->query($sqlStmt1); echo " ".PHP_EOL; echo " ".PHP_EOL; echo " ".PHP_EOL; echo " ".PHP_EOL; echo "

".PHP_EOL; echo " "; //if this is a post if ($_SERVER["REQUEST_METHOD"] == "POST") { // determine what is set and build a query // echo "

".PHP_EOL; // echo "

".PHP_EOL; // echo " ".PHP_EOL; $scriptData = " "; echo $scriptData.PHP_EOL; echo "

".PHP_EOL; echo " ".PHP_EOL; echo " ".PHP_EOL; echo " ".PHP_EOL; echo " ".PHP_EOL; echo " ".PHP_EOL; echo " ".PHP_EOL; echo " ".PHP_EOL; echo " ".PHP_EOL; echo " ".PHP_EOL; echo " ".PHP_EOL; echo " ".PHP_EOL; if (!isset($club) || $club=="") { if (isset($club) and strlen($club) > 0) { $club = $club; } else { if (!isset($ageg) or strlen($ageg) == 0) { $club = "ALL"; } } } if ((isset($club) and strlen($club) > 0) || (isset($ageg) and strlen($ageg) > 0)) { if ($club == "ALL") { $sqlStmt = "SELECT * FROM ".$scheduleDbTable." "; $sqlOrder = " ORDER BY `Gm#`"; } else { $sqlStmt = "SELECT * FROM ".$scheduleDbTable." WHERE "; if (isset($team) and strlen($team) > 0) { $sqlClub = "(`Home Team`='".$club." ".$team."' OR `Visiting Team`='".$club." ".$team."')"; $sqlAND = " AND "; $sqlOrder = " ORDER BY Date, Time"; } else if (isset($club) and strlen($club) > 0) { $sqlClub = "(`Home Team` LIKE '".$club."%' OR `Visiting Team` LIKE '".$club."%')"; $sqlAND = " AND "; $sqlOrder = " ORDER BY Date, Time"; } else { $sqlClub = ""; $sqlAND = ""; $sqlOrder = " ORDER BY `Div`, Date, Time"; } if (isset($div) and strlen($div) > 0) { $sqlStmt .= $sqlClub.$sqlAND."Age='".$ageg."' AND `Div`=".$div; } else if (isset($ageg) and strlen($ageg) > 0) { $sqlStmt .= $sqlClub.$sqlAND."Age='".$ageg."'"; } else { $sqlStmt .= $sqlClub; } } $sqlStmt .= $sqlOrder; // echo "VML- ",$sqlStmt; //get schedule if ($showSchedule) { $result = $db->query($sqlStmt); if($result && $result->num_rows>0) { while ($rs = $result->fetch_array()) { $dateTime = new DateTimeImmutable($rs['Date'] . " " . $rs['Time']); list($date, $time, $ampm) = explode(" ", $dateTime->format('m/d/Y h:i A')); if (isGameTBA($rs['Date'], $rs['Time'])) { $date = "TBA"; $time = "TBA"; $ampm = ""; } else if (wasGameForfeited($rs['Date'], $rs['Time'])) { $date = "FORFEIT"; $time = "FORFEIT"; $ampm = ""; } echo " ".PHP_EOL; echo " ".PHP_EOL; echo " ".PHP_EOL; echo " ".PHP_EOL; echo " ".PHP_EOL; echo " ".PHP_EOL; echo " ".PHP_EOL; echo " ".PHP_EOL; echo " ".PHP_EOL; echo " ".PHP_EOL; } } } echo " ".PHP_EOL; echo "

Gm#	Age	Div	Date	Time	Home Team	Visiting Team	Field
".$rs['Gm#']."	".$rs['Age']."	".$rs['Div']."	".$date."	".$time." ".$ampm."	".$rs['Home Team']."	".$rs['Visiting Team']."	".$rs['Field']."

".PHP_EOL; // echo "

".PHP_EOL; } } ?>