Division Two Fixtures 2018 - Walkden and District Tennis League

26/04/2018

Ellesmere B v Parrfold 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 ‘Ellesmere B Win’
WHEN `Awayteam_win`=1
THEN ‘Parrfold A Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Parrfold 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]

Markland Hill v Bolton C & T

[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 ‘Markland Hill Win’
WHEN `Awayteam_win`=1
THEN ‘Bolton T & C Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Bolton’
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]

Open Week v Lostock A

No Match

Leigh B v Claremont 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 ‘Leigh B Win’
WHEN `Awayteam_win`=1
THEN ‘Claremont B Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Claremont B’
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]

03/05/2018

Markland Hill v Parrfold 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 ‘Markland Hill Win’
WHEN `Awayteam_win`=1
THEN ‘Parrfold A Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Parrfold A’
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]

Bolton C & T v Lostock 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 ‘Bolton C & T Win’
WHEN `Awayteam_win`=1
THEN ‘Lostock A Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Lostock A’
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]

Leigh B v Open Week

No Match

Claremont B v Ellesmere 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 ‘Claremont B Win’
WHEN `Awayteam_win`=1
THEN ‘Ellesmere B Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Ellesmere 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

Open Week v Markland Hill

No Match

Parrfold A v Leigh 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 A Win’
WHEN `Awayteam_win`=1
THEN ‘Leigh B Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Leigh 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]

Claremont B v Lostock 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 ‘Claremont B Win’
WHEN `Awayteam_win`=1
THEN ‘Lostock A Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Lostock A’
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]

Bolton C & T v Ellesmere 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 ‘Bolton C & T Win’
WHEN `Awayteam_win`=1
THEN ‘Ellesmere B Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Ellesmere 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

Claremont B v Open Week

No Match

Parrfold A v Bolton C & T

[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 A Win’
WHEN `Awayteam_win`=1
THEN ‘Bolton C & T Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Bolton’
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]

Lostock A v Leigh 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 A Win’
WHEN `Awayteam_win`=1
THEN ‘Leigh B Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Leigh 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]

Markland Hill v Ellesmere 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 ‘Markland Hill Win’
WHEN `Awayteam_win`=1
THEN ‘Ellesmere B Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Ellesmere 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]

24/05/2018

Ellesmere B v Open Week

No Match

Markland Hill v Claremont 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 ‘Markland Hill Win’
WHEN `Awayteam_win`=1
THEN ‘Claremont B Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Claremont 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]

Parrfold A v Lostock 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 ‘Parrfold A Win’
WHEN `Awayteam_win`=1
THEN ‘Lostock A Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Lostock A’
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]

Leigh B v Bolton C & T

[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 ‘Leigh B Win’
WHEN `Awayteam_win`=1
THEN ‘Bolton C & T Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Bolton’
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)

Bolton C & T v Leigh B

Markland Hill v Parrfold A

Claremont B v Ellesmere B

Lostock A v Bye

07/06/2018

Leigh B v Ellesmere 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 ‘Leigh B Win’
WHEN `Awayteam_win`=1
THEN ‘Ellesmere B Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Ellesmere 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]

Claremont B v Parrfold 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 ‘Claremont B Win’
WHEN `Awayteam_win`=1
THEN ‘Parrfold A Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Parrfold A’
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]

Bolton C & T v Open Week

No Match

Lostock A v Markland Hill

[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 A Win’
WHEN `Awayteam_win`=1
THEN ‘Markland Hill Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Markland Hill’
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

Ellesmere B v Lostock 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 ‘Ellesmere B Win’
WHEN `Awayteam_win`=1
THEN ‘Lostock A Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Lostock 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]

Leigh B v Markland Hill

[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 ‘Leigh B Win’
WHEN `Awayteam_win`=1
THEN ‘Markland Hill Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Markland Hill’
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]

Bolton C & T v Claremont 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 ‘Bolton C & T Win’
WHEN `Awayteam_win`=1
THEN ‘Claremont B Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Claremont 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]

Parrfold A v Open Week

No Match

21/06/2018

Parrfold A v Ellesmere 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 A Win’
WHEN `Awayteam_win`=1
THEN ‘Ellesmere B Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Ellesmere 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]

Bolton C & T v Markland Hill

[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 ‘Bolton C & T Win’
WHEN `Awayteam_win`=1
THEN ‘Markland Hill Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Markland Hill’
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]

Lostock A v Open Week

No Match

Claremont B v Leigh 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 ‘Claremont B Win’
WHEN `Awayteam_win`=1
THEN ‘Leigh B Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Leigh 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]

28/06/2018 (Cup Semi-Final)

Bolton C & T v Parrfold A (Ladies)

Leigh B v Markland Hill (Men)

Ellesmere B v Lostock (Men)

Ellesmere B v Lostock (Ladies)

05/07/2018

Parrfold A v Markland Hill

[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 A Win’
WHEN `Awayteam_win`=1
THEN ‘Markland Hill Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Markland Hill’
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]

Lostock A v Bolton C & T

[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 A Win’
WHEN `Awayteam_win`=1
THEN ‘Bolton C & T Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Bolton’
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 Leigh B

No Match

Ellesmere B v Claremont 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 ‘Ellesmere B Win’
WHEN `Awayteam_win`=1
THEN ‘Claremont B Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Claremont 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]

12/07/2018

Markland Hill v Open Week

No Match

Leigh B v Parrfold 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 ‘Leigh B Win’
WHEN `Awayteam_win`=1
THEN ‘Parrfold A Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Parrfold 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]

Lostock A v Claremont 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 A Win’
WHEN `Awayteam_win`=1
THEN ‘Claremont B Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Claremont 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]

Ellesmere B v Bolton C & T

[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 ‘Ellesmere B Win’
WHEN `Awayteam_win`=1
THEN ‘Bolton C & T Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Bolton’
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

Open Week v Claremont B

No Match

Bolton C & T v Parrfold 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 ‘Bolton C & T Win’
WHEN `Awayteam_win`=1
THEN ‘Parrfold A Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Parrfold 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]

Leigh B v Lostock 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 ‘Leigh B Win’
WHEN `Awayteam_win`=1
THEN ‘Lostock A Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Lostock 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]

Ellesmere B v Markland Hill

[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 ‘Ellesmere B Win’
WHEN `Awayteam_win`=1
THEN ‘Markland Hill Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Markland Hill’
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

Open Week v Ellesmere B

No Match

Claremont B v Markland Hill

[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 ‘Claremont B Win’
WHEN `Awayteam_win`=1
THEN ‘Markland Hill Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Markland Hill’
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]

Lostock A v Parrfold 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 A Win’
WHEN `Awayteam_win`=1
THEN ‘Parrfold A Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Parrfold A’
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]

Bolton C & T v Leigh 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 ‘Bolton C & T Win’
WHEN `Awayteam_win`=1
THEN ‘Leigh B Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Leigh 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]

02/08/2018

Ellesmere B v Leigh 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 ‘Ellesmere B Win’
WHEN `Awayteam_win`=1
THEN ‘Leigh B Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Leigh 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]

Parrfold A v Claremont 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 A Win’
WHEN `Awayteam_win`=1
THEN ‘Claremont B Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Claremont 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]

Open Week v Bolton C & T

No Match

Markland Hill v Lostock 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 ‘Markland Hill Win’
WHEN `Awayteam_win`=1
THEN ‘Lostock A Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Lostock A’
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

Lostock A v Ellesmere 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 A Win’
WHEN `Awayteam_win`=1
THEN ‘Ellesmere B Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Ellesmere 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]

Markland Hill v Leigh 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 ‘Markland Hill Win’
WHEN `Awayteam_win`=1
THEN ‘Leigh B Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Leigh 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]

Claremont B v Bolton C & T

[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 ‘Claremont B Win’
WHEN `Awayteam_win`=1
THEN ‘Bolton C & T Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division2_results_2017
WHERE HomeTeam OR AwayTeam = ‘Bolton’
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 Parrfold A

No Match

16/08/2018 (Cup Final)

Leigh B v Lostock A (Men)

Parrfold A v Lostock A (Ladies)