Division Three Fixtures 2018

26/04/2018

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`) = ‘2018-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`) = ‘2018-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/2018

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`) = ‘2018-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`) = ‘2018-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`) = ‘2018-05-03′”)

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

10/05/2018

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`) = ‘2018-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`) = ‘2018-05-10′”)

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

17/05/2018

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`) = ‘2018-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`) = ‘2018-05-17′”)

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

24/05/2018

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`) = ‘2018-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`) = ‘2018-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`) = ‘2018-05-24′”)

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

31/05/2018 (First round Cup Match)

Astley A v Roe Green B Parrfold B v Bye Lostock B v Winton Astley B v Bye

07/06/2018

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`) = ‘2018-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`) = ‘2018-06-07′”)

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

14/06/2018

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`) = ‘2018-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`) = ‘2018-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/2018

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`) = ‘2018-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`) = ‘2018-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/2018 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/2018

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`) = ‘2018-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`) = ‘2018-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`) = ‘2018-07-05′”)

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

12/07/2018

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`) = ‘2018-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`) = ‘2018-07-12′”)

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

19/07/2018

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`) = ‘2018-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`) = ‘2018-07-19′”)

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

26/07/2018

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`) = ‘2018-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`) = ‘2018-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/2018

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`) = ‘2018-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`) = ‘2018-08-02′”)

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

09/08/2018

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`) = ‘2018-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`) = ‘2018-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/2018 (Cup Final)

Roe Green B v Lostock B (Men) Parrfold B v Lostock B (ladies)