Division 3 fixtures 2017 - Walkden and District Tennis League

April FixturesMay FixturesFirst Round Cup MatchesJune FixturesCup Semi-Final MatchesJuly FixturesAugust FixturesCup Final

26/04/2017

Parrfold B v Astley A

[insert_php] try {
include ‘../vars.php’;
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
foreach($con->query(“SELECT `HomeTeam`,`AwayTeam`,`HomeTeam_win`,`awayteam_win`,`r_off`, `Draw` ,( CASE WHEN `hometeam_win`=1
THEN ‘Parrfold B Win’
WHEN `Awayteam_win`=1
THEN ‘Astley A Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division3_results_2017
WHERE AwayTeam = ‘Astley A’
AND DATE(`date`) = ‘2017-04-26′”)

as $row) {
Print $row[‘Result’]; //etc…
}
$con = null;
} catch(PDOException $e) {
echo ‘ERROR: ‘ . $e->getMessage();
} // end try
[/insert_php]

Roe Green B v Winton

[insert_php] try {
include ‘../vars.php’;
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
foreach($con->query(“SELECT `HomeTeam`,`AwayTeam`,`HomeTeam_win` AS Home_Win,`awayteam_win` AS Away_Win ,`r_off` AS Rain_Off, Draw AS Draw,( CASE WHEN `hometeam_win`=1
THEN ‘Roe Green B Win’
WHEN `Awayteam_win`=1
THEN ‘Winton Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division3_results_2017
WHERE HomeTeam OR AwayTeam = ‘Winton’
AND DATE(`date`) = ‘2017-04-26′”)

as $row) {
Print $row[‘Result’]; //etc…
}
$con = null;
} catch(PDOException $e) {
echo ‘ERROR: ‘ . $e->getMessage();
} // end try
[/insert_php]

Astley B v Open Week

No Match

Lostock B v Open Week

No Match

03/05/2017

Parrfold B v Winton

[insert_php] try {
include ‘../vars.php’;
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
foreach($con->query(“SELECT `HomeTeam`,`AwayTeam`,`HomeTeam_win` AS Home_Win,`awayteam_win` AS Away_Win ,`r_off` AS Rain_Off, Draw AS Draw,( CASE WHEN `hometeam_win`=1
THEN ‘Parrfold B Win’
WHEN `Awayteam_win`=1
THEN ‘Winton Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division3_results_2017
WHERE HomeTeam OR AwayTeam = ‘Winton’
AND DATE(`date`) = ‘2017-05-03′”)

as $row) {
Print $row[‘Result’]; //etc…
}
$con = null;
} catch(PDOException $e) {
echo ‘ERROR: ‘ . $e->getMessage();
} // end try
[/insert_php]

Lostock B v Roe Green B

[insert_php] try {
include ‘../vars.php’;
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
foreach($con->query(“SELECT `HomeTeam`,`AwayTeam`,`HomeTeam_win` AS Home_Win,`awayteam_win` AS Away_Win ,`r_off` AS Rain_Off, Draw AS Draw,( CASE WHEN `hometeam_win`=1
THEN ‘Lostock B Win’
WHEN `Awayteam_win`=1
THEN ‘Roe Green B Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division3_results_2017
WHERE HomeTeam OR AwayTeam = ‘Roe Green B’
AND DATE(`date`) = ‘2017-05-03′”)

as $row) {
Print $row[‘Result’]; //etc…
}
$con = null;
} catch(PDOException $e) {
echo ‘ERROR: ‘ . $e->getMessage();
} // end try
[/insert_php]

Open Week v Open Week

No Match

Astley A v Astley B

[insert_php] try {
include ‘../vars.php’;
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
foreach($con->query(“SELECT `HomeTeam`,`AwayTeam`,`HomeTeam_win` AS Home_Win,`awayteam_win` AS Away_Win ,`r_off` AS Rain_Off, Draw AS Draw,( CASE WHEN `hometeam_win`=1
THEN ‘Astley A Win’
WHEN `Awayteam_win`=1
THEN ‘Astley B Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division3_results_2017
WHERE HomeTeam OR AwayTeam = ‘Astley B’
AND DATE(`date`) = ‘2017-05-03′”)

as $row) {
Print $row[‘Result’]; //etc…
}
$con = null;
} catch(PDOException $e) {
echo ‘ERROR: ‘ . $e->getMessage();
} // end try
[/insert_php]

10/05/2017

Winton v Open Week

No Match

Open Week v Parrfold B

No Match

Lostock B v Astley B

[insert_php] try {
include ‘../vars.php’;
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
foreach($con->query(“SELECT `HomeTeam`,`AwayTeam`,`HomeTeam_win` AS Home_Win,`awayteam_win` AS Away_Win ,`r_off` AS Rain_Off, Draw AS Draw,( CASE WHEN `hometeam_win`=1
THEN ‘Lostock B Win’
WHEN `Awayteam_win`=1
THEN ‘Astley B Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division3_results_2017
WHERE HomeTeam OR AwayTeam = ‘Astley B’
AND DATE(`date`) = ‘2017-05-10′”)

as $row) {
Print $row[‘Result’]; //etc…
}
$con = null;
} catch(PDOException $e) {
echo ‘ERROR: ‘ . $e->getMessage();
} // end try
[/insert_php]

Astley A v Roe Green B

[insert_php] try {
include ‘../vars.php’;
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
foreach($con->query(“SELECT `HomeTeam`,`AwayTeam`,`HomeTeam_win` AS Home_Win,`awayteam_win` AS Away_Win ,`r_off` AS Rain_Off, Draw AS Draw,( CASE WHEN `hometeam_win`=1
THEN ‘Astley A Win’
WHEN `Awayteam_win`=1
THEN ‘Roe Green B Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division3_results_2017
WHERE HomeTeam OR AwayTeam = ‘Roe Green B’
AND DATE(`date`) = ‘2017-05-10′”)

as $row) {
Print $row[‘Result’]; //etc…
}
$con = null;
} catch(PDOException $e) {
echo ‘ERROR: ‘ . $e->getMessage();
} // end try
[/insert_php]

17/05/2017

Open Week v Astley B

No Match

Roe Green B v Parrfold B

[insert_php] try {
include ‘../vars.php’;
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
foreach($con->query(“SELECT `HomeTeam`,`AwayTeam`,`HomeTeam_win` AS Home_Win,`awayteam_win` AS Away_Win ,`r_off` AS Rain_Off, Draw AS Draw,( CASE WHEN `hometeam_win`=1
THEN ‘Roe Green B Win’
WHEN `Awayteam_win`=1
THEN ‘Parrfold B Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division3_results_2017
WHERE HomeTeam OR AwayTeam = ‘Parrfold B’
AND DATE(`date`) = ‘2017-05-17′”)

as $row) {
Print $row[‘Result’]; //etc…
}
$con = null;
} catch(PDOException $e) {
echo ‘ERROR: ‘ . $e->getMessage();
} // end try
[/insert_php]

Open Week v Lostock B

No Match

Astley A v Winton

[insert_php] try {
include ‘../vars.php’;
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
foreach($con->query(“SELECT `HomeTeam`,`AwayTeam`,`HomeTeam_win` AS Home_Win,`awayteam_win` AS Away_Win ,`r_off` AS Rain_Off, Draw AS Draw,( CASE WHEN `hometeam_win`=1
THEN ‘Astley A Win’
WHEN `Awayteam_win`=1
THEN ‘Winton Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division3_results_2017
WHERE HomeTeam OR AwayTeam = ‘Winton’
AND DATE(`date`) = ‘2017-05-17′”)

as $row) {
Print $row[‘Result’]; //etc…
}
$con = null;
} catch(PDOException $e) {
echo ‘ERROR: ‘ . $e->getMessage();
} // end try
[/insert_php]

24/05/2017

Open Week v Astley A

No Match

Astley B v Winton

[insert_php] try {
include ‘../vars.php’;
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
foreach($con->query(“SELECT `HomeTeam`,`AwayTeam`,`HomeTeam_win` AS Home_Win,`awayteam_win` AS Away_Win ,`r_off` AS Rain_Off, Draw AS Draw,( CASE WHEN `hometeam_win`=1
THEN ‘Astley B Win’
WHEN `Awayteam_win`=1
THEN ‘Winton Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division3_results_2017
WHERE HomeTeam OR AwayTeam = ‘Winton’
AND DATE(`date`) = ‘2017-05-24′”)

as $row) {
Print $row[‘Result’]; //etc…
}
$con = null;
} catch(PDOException $e) {
echo ‘ERROR: ‘ . $e->getMessage();
} // end try
[/insert_php]

Lostock B v Parrfold B

[insert_php] try {
include ‘../vars.php’;
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
foreach($con->query(“SELECT `HomeTeam`,`AwayTeam`,`HomeTeam_win` AS Home_Win,`awayteam_win` AS Away_Win ,`r_off` AS Rain_Off, Draw AS Draw,( CASE WHEN `hometeam_win`=1
THEN ‘Lostock B Win’
WHEN `Awayteam_win`=1
THEN ‘Parrfold B Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division3_results_2017
WHERE HomeTeam OR AwayTeam = ‘Parrfold B’
AND DATE(`date`) = ‘2017-05-24′”)

as $row) {
Print $row[‘Result’]; //etc…
}
$con = null;
} catch(PDOException $e) {
echo ‘ERROR: ‘ . $e->getMessage();
} // end try
[/insert_php]

Astley A v Winton

[insert_php] try {
include ‘../vars.php’;
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
foreach($con->query(“SELECT `HomeTeam`,`AwayTeam`,`HomeTeam_win` AS Home_Win,`awayteam_win` AS Away_Win ,`r_off` AS Rain_Off, Draw AS Draw,( CASE WHEN `hometeam_win`=1
THEN ‘Astley A Win’
WHEN `Awayteam_win`=1
THEN ‘Winton Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division3_results_2017
WHERE HomeTeam OR AwayTeam = ‘Winton’
AND DATE(`date`) = ‘2017-05-24′”)

as $row) {
Print $row[‘Result’]; //etc…
}
$con = null;
} catch(PDOException $e) {
echo ‘ERROR: ‘ . $e->getMessage();
} // end try
[/insert_php]

31/05/2017 (First round Cup Match)

Astley A v Roe Green B

Parrfold B v Bye

Lostock B v Winton

Astley B v Bye

07/06/2017

Astley A v Open Week

No Match

Parrfold B v Astley B

[insert_php] try {
include ‘../vars.php’;
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
foreach($con->query(“SELECT `HomeTeam`,`AwayTeam`,`HomeTeam_win` AS Home_Win,`awayteam_win` AS Away_Win ,`r_off` AS Rain_Off, Draw AS Draw,( CASE WHEN `hometeam_win`=1
THEN ‘Parrfold B Win’
WHEN `Awayteam_win`=1
THEN ‘Astley B Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division3_results_2017
WHERE HomeTeam OR AwayTeam = ‘Astley B’
AND DATE(`date`) = ‘2017-06-07′”)

as $row) {
Print $row[‘Result’]; //etc…
}
$con = null;
} catch(PDOException $e) {
echo ‘ERROR: ‘ . $e->getMessage();
} // end try
[/insert_php]

Open Week v Roe Green B

No Match

Winton v Lostock B

[insert_php] try {
include ‘../vars.php’;
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
foreach($con->query(“SELECT `HomeTeam`,`AwayTeam`,`HomeTeam_win` AS Home_Win,`awayteam_win` AS Away_Win ,`r_off` AS Rain_Off, Draw AS Draw,( CASE WHEN `hometeam_win`=1
THEN ‘Winton Win’
WHEN `Awayteam_win`=1
THEN ‘Lostock B Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division3_results_2017
WHERE HomeTeam OR AwayTeam = ‘Lostock B’
AND DATE(`date`) = ‘2017-06-07′”)

as $row) {
Print $row[‘Result’]; //etc…
}
$con = null;
} catch(PDOException $e) {
echo ‘ERROR: ‘ . $e->getMessage();
} // end try
[/insert_php]

14/06/2017

Lostock B v Astley A

[insert_php] try {
include ‘../vars.php’;
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
foreach($con->query(“SELECT `HomeTeam`,`AwayTeam`,`HomeTeam_win` AS Home_Win,`awayteam_win` AS Away_Win ,`r_off` AS Rain_Off, Draw AS Draw,( CASE WHEN `hometeam_win`=1
THEN ‘Lostock B Win’
WHEN `Awayteam_win`=1
THEN ‘Astley A Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division3_results_2017
WHERE HomeTeam OR AwayTeam = ‘Astley A’
AND DATE(`date`) = ‘2017-06-14′”)

as $row) {
Print $row[‘Result’]; //etc…
}
$con = null;
} catch(PDOException $e) {
echo ‘ERROR: ‘ . $e->getMessage();
} // end try
[/insert_php]

Winton v Open Week

No Match

Astley B v Roe Green B

[insert_php] try {
include ‘../vars.php’;
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
foreach($con->query(“SELECT `HomeTeam`,`AwayTeam`,`HomeTeam_win` AS Home_Win,`awayteam_win` AS Away_Win ,`r_off` AS Rain_Off, Draw AS Draw,( CASE WHEN `hometeam_win`=1
THEN ‘Astley B Win’
WHEN `Awayteam_win`=1
THEN ‘Roe Green B Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division3_results_2017
WHERE HomeTeam OR AwayTeam = ‘Roe Green B’
AND DATE(`date`) = ‘2017-06-14′”)

as $row) {
Print $row[‘Result’]; //etc…
}
$con = null;
} catch(PDOException $e) {
echo ‘ERROR: ‘ . $e->getMessage();
} // end try
[/insert_php]

Open Week v Parrfold B

No Match

21/06/2017

Astley A v Parrfold B

[insert_php] try {
include ‘../vars.php’;
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
foreach($con->query(“SELECT `HomeTeam`,`AwayTeam`,`HomeTeam_win` AS Home_Win,`awayteam_win` AS Away_Win ,`r_off` AS Rain_Off, Draw AS Draw,( CASE WHEN `hometeam_win`=1
THEN ‘Astley A Win’
WHEN `Awayteam_win`=1
THEN ‘Parrfold B Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division3_results_2017
WHERE HomeTeam OR AwayTeam = ‘Parrfold B’
AND DATE(`date`) = ‘2017-06-21′”)

as $row) {
Print $row[‘Result’]; //etc…
}
$con = null;
} catch(PDOException $e) {
echo ‘ERROR: ‘ . $e->getMessage();
} // end try
[/insert_php]

Winton v Roe Green B

[insert_php] try {
include ‘../vars.php’;
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
foreach($con->query(“SELECT `HomeTeam`,`AwayTeam`,`HomeTeam_win` AS Home_Win,`awayteam_win` AS Away_Win ,`r_off` AS Rain_Off, Draw AS Draw,( CASE WHEN `hometeam_win`=1
THEN ‘Winton Win’
WHEN `Awayteam_win`=1
THEN ‘Roe Green B Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division3_results_2017
WHERE HomeTeam OR AwayTeam = ‘Roe Green B’
AND DATE(`date`) = ‘2017-06-21′”)

as $row) {
Print $row[‘Result’]; //etc…
}
$con = null;
} catch(PDOException $e) {
echo ‘ERROR: ‘ . $e->getMessage();
} // end try
[/insert_php]

Open Week v Lostock B

No Match

Open Week v Astley B

No Match

28/06/2017 Cup Semi Final

Astley A v Parrfold B (Ladies)

Roe Green B v Parrfold B (Men)

Lostock B v Astley B (Men)

Lostock B v Astley B (Ladies)

05/07/2017

Winton v Parrfold B

[insert_php] try {
include ‘../vars.php’;
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
foreach($con->query(“SELECT `HomeTeam`,`AwayTeam`,`HomeTeam_win` AS Home_Win,`awayteam_win` AS Away_Win ,`r_off` AS Rain_Off, Draw AS Draw,( CASE WHEN `hometeam_win`=1
THEN ‘Winton Win’
WHEN `Awayteam_win`=1
THEN ‘Parrfold B Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division3_results_2017
WHERE HomeTeam OR AwayTeam = ‘Parrfold B’
AND DATE(`date`) = ‘2017-07-05′”)

as $row) {
Print $row[‘Result’]; //etc…
}
$con = null;
} catch(PDOException $e) {
echo ‘ERROR: ‘ . $e->getMessage();
} // end try
[/insert_php]

Roe Green B v Lostock B

[insert_php] try {
include ‘../vars.php’;
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
foreach($con->query(“SELECT `HomeTeam`,`AwayTeam`,`HomeTeam_win` AS Home_Win,`awayteam_win` AS Away_Win ,`r_off` AS Rain_Off, Draw AS Draw,( CASE WHEN `hometeam_win`=1
THEN ‘Roe Green B Win’
WHEN `Awayteam_win`=1
THEN ‘Lostock B Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division3_results_2017
WHERE HomeTeam OR AwayTeam = ‘Lostock B’
AND DATE(`date`) = ‘2017-07-05′”)

as $row) {
Print $row[‘Result’]; //etc…
}
$con = null;
} catch(PDOException $e) {
echo ‘ERROR: ‘ . $e->getMessage();
} // end try
[/insert_php]

Open Week v Open Week

No Match

Astley B v Astley A

[insert_php] try {
include ‘../vars.php’;
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
foreach($con->query(“SELECT `HomeTeam`,`AwayTeam`,`HomeTeam_win` AS Home_Win,`awayteam_win` AS Away_Win ,`r_off` AS Rain_Off, Draw AS Draw,( CASE WHEN `hometeam_win`=1
THEN ‘Astley B Win’
WHEN `Awayteam_win`=1
THEN ‘Astley A Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division3_results_2017
WHERE HomeTeam OR AwayTeam = ‘Astley A’
AND DATE(`date`) = ‘2017-07-05′”)

as $row) {
Print $row[‘Result’]; //etc…
}
$con = null;
} catch(PDOException $e) {
echo ‘ERROR: ‘ . $e->getMessage();
} // end try
[/insert_php]

12/07/2017

Open Week v Winton

No Match

Parrfold B v Open Week

No Match

Astley B v Lostock B

[insert_php] try {
include ‘../vars.php’;
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
foreach($con->query(“SELECT `HomeTeam`,`AwayTeam`,`HomeTeam_win` AS Home_Win,`awayteam_win` AS Away_Win ,`r_off` AS Rain_Off, Draw AS Draw,( CASE WHEN `hometeam_win`=1
THEN ‘Astley B Win’
WHEN `Awayteam_win`=1
THEN ‘Lostock B Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division3_results_2017
WHERE HomeTeam OR AwayTeam = ‘Lostock B’
AND DATE(`date`) = ‘2017-07-12′”)

as $row) {
Print $row[‘Result’]; //etc…
}
$con = null;
} catch(PDOException $e) {
echo ‘ERROR: ‘ . $e->getMessage();
} // end try
[/insert_php]

Roe Green B v Astley A

[insert_php] try {
include ‘../vars.php’;
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
foreach($con->query(“SELECT `HomeTeam`,`AwayTeam`,`HomeTeam_win` AS Home_Win,`awayteam_win` AS Away_Win ,`r_off` AS Rain_Off, Draw AS Draw,( CASE WHEN `hometeam_win`=1
THEN ‘Roe Green B Win’
WHEN `Awayteam_win`=1
THEN ‘Astley A Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division3_results_2017
WHERE HomeTeam OR AwayTeam = ‘Astley A’
AND DATE(`date`) = ‘2017-07-12′”)

as $row) {
Print $row[‘Result’]; //etc…
}
$con = null;
} catch(PDOException $e) {
echo ‘ERROR: ‘ . $e->getMessage();
} // end try
[/insert_php]

19/07/2017

Astley B v Open Week

No Match

Parrfold B v Roe Green B

[insert_php] try {
include ‘../vars.php’;
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
foreach($con->query(“SELECT `HomeTeam`,`AwayTeam`,`HomeTeam_win` AS Home_Win,`awayteam_win` AS Away_Win ,`r_off` AS Rain_Off, Draw AS Draw,( CASE WHEN `hometeam_win`=1
THEN ‘Parrfold B Win’
WHEN `Awayteam_win`=1
THEN ‘Roe Green B Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division3_results_2017
WHERE HomeTeam OR AwayTeam = ‘Roe Green B’
AND DATE(`date`) = ‘2017-07-19′”)

as $row) {
Print $row[‘Result’]; //etc…
}
$con = null;
} catch(PDOException $e) {
echo ‘ERROR: ‘ . $e->getMessage();
} // end try
[/insert_php]

Lostock B v Open Week

No Match

Winton v Astley A

[insert_php] try {
include ‘../vars.php’;
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
foreach($con->query(“SELECT `HomeTeam`,`AwayTeam`,`HomeTeam_win` AS Home_Win,`awayteam_win` AS Away_Win ,`r_off` AS Rain_Off, Draw AS Draw,( CASE WHEN `hometeam_win`=1
THEN ‘Winton Win’
WHEN `Awayteam_win`=1
THEN ‘Astley A Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division3_results_2017
WHERE HomeTeam OR AwayTeam = ‘Astley A’
AND DATE(`date`) = ‘2017-07-19′”)

as $row) {
Print $row[‘Result’]; //etc…
}
$con = null;
} catch(PDOException $e) {
echo ‘ERROR: ‘ . $e->getMessage();
} // end try
[/insert_php]

26/07/2017

Astley A v Open Week

No Match

Winton v Astley B

[insert_php] try {
include ‘../vars.php’;
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
foreach($con->query(“SELECT `HomeTeam`,`AwayTeam`,`HomeTeam_win` AS Home_Win,`awayteam_win` AS Away_Win ,`r_off` AS Rain_Off, Draw AS Draw,( CASE WHEN `hometeam_win`=1
THEN ‘Winton Win’
WHEN `Awayteam_win`=1
THEN ‘Astley B Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division3_results_2017
WHERE HomeTeam OR AwayTeam = ‘Astley B’
AND DATE(`date`) = ‘2017-07-26′”)

as $row) {
Print $row[‘Result’]; //etc…
}
$con = null;
} catch(PDOException $e) {
echo ‘ERROR: ‘ . $e->getMessage();
} // end try
[/insert_php]

Parrfold B v Lostock B

[insert_php] try {
include ‘../vars.php’;
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
foreach($con->query(“SELECT `HomeTeam`,`AwayTeam`,`HomeTeam_win` AS Home_Win,`awayteam_win` AS Away_Win ,`r_off` AS Rain_Off, Draw AS Draw,( CASE WHEN `hometeam_win`=1
THEN ‘Parrfold B Win’
WHEN `Awayteam_win`=1
THEN ‘Lostock B Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division3_results_2017
WHERE HomeTeam OR AwayTeam = ‘Lostock B’
AND DATE(`date`) = ‘2017-07-26′”)

as $row) {
Print $row[‘Result’]; //etc…
}
$con = null;
} catch(PDOException $e) {
echo ‘ERROR: ‘ . $e->getMessage();
} // end try
[/insert_php]

Open Week v Roe Green B

No Match

02/08/2017

Open Week v Astley A

No Match

Astley B v Parrfold B

[insert_php] try {
include ‘../vars.php’;
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
foreach($con->query(“SELECT `HomeTeam`,`AwayTeam`,`HomeTeam_win` AS Home_Win,`awayteam_win` AS Away_Win ,`r_off` AS Rain_Off, Draw AS Draw,( CASE WHEN `hometeam_win`=1
THEN ‘Astley B Win’
WHEN `Awayteam_win`=1
THEN ‘Parrfold B Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division3_results_2017
WHERE HomeTeam OR AwayTeam = ‘Parrfold B’
AND DATE(`date`) = ‘2017-08-02′”)

as $row) {
Print $row[‘Result’]; //etc…
}
$con = null;
} catch(PDOException $e) {
echo ‘ERROR: ‘ . $e->getMessage();
} // end try
[/insert_php]

Roe Green B v Open Week

No Match

Lostock B v Winton

[insert_php] try {
include ‘../vars.php’;
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
foreach($con->query(“SELECT `HomeTeam`,`AwayTeam`,`HomeTeam_win` AS Home_Win,`awayteam_win` AS Away_Win ,`r_off` AS Rain_Off, Draw AS Draw,( CASE WHEN `hometeam_win`=1
THEN ‘Lostock B Win’
WHEN `Awayteam_win`=1
THEN ‘Winton Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division3_results_2017
WHERE HomeTeam OR AwayTeam = ‘Winton’
AND DATE(`date`) = ‘2017-08-02′”)

as $row) {
Print $row[‘Result’]; //etc…
}
$con = null;
} catch(PDOException $e) {
echo ‘ERROR: ‘ . $e->getMessage();
} // end try
[/insert_php]

09/08/2017

Astley A v Lostock B

[insert_php] try {
include ‘../vars.php’;
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
foreach($con->query(“SELECT `HomeTeam`,`AwayTeam`,`HomeTeam_win` AS Home_Win,`awayteam_win` AS Away_Win ,`r_off` AS Rain_Off, Draw AS Draw,( CASE WHEN `hometeam_win`=1
THEN ‘Astley A Win’
WHEN `Awayteam_win`=1
THEN ‘Lostock B Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division3_results_2017
WHERE HomeTeam OR AwayTeam = ‘Lostock B’
AND DATE(`date`) = ‘2017-08-09′”)

as $row) {
Print $row[‘Result’]; //etc…
}
$con = null;
} catch(PDOException $e) {
echo ‘ERROR: ‘ . $e->getMessage();
} // end try
[/insert_php]

Open Week v Winton

No Match

Roe Green B v Astley B

[insert_php] try {
include ‘../vars.php’;
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
foreach($con->query(“SELECT `HomeTeam`,`AwayTeam`,`HomeTeam_win` AS Home_Win,`awayteam_win` AS Away_Win ,`r_off` AS Rain_Off, Draw AS Draw,( CASE WHEN `hometeam_win`=1
THEN ‘Roe Green B Win’
WHEN `Awayteam_win`=1
THEN ‘Astley B Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division3_results_2017
WHERE HomeTeam OR AwayTeam = ‘Astley B’
AND DATE(`date`) = ‘2017-08-09′”)

as $row) {
Print $row[‘Result’]; //etc…
}
$con = null;
} catch(PDOException $e) {
echo ‘ERROR: ‘ . $e->getMessage();
} // end try
[/insert_php]

Parrfold B v Open Week

No Match

16/08/2017 (Cup Final)

Roe Green B v Lostock B (Men)

Parrfold B v Lostock B (ladies)