Division One Fixtures 2018

26/04/2018

Tyldesley v Ellesmere 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 ‘Monton Win’
WHEN Awayteam_win=1
THEN ‘Roe Green A win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division1_results_2018
WHERE AwayTeam = ‘Roe Green 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]

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

David Lloyd v Open Week

No Match

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

03/05/2018

Tyldesley v Roe Green 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 ‘Tyldesley Win’
WHEN Awayteam_win=1
THEN ‘Roe Green A win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division1_results_2017
WHERE AwayTeam = ‘Roe Green 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]

David Lloyd v Monton

[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 ‘David Lloyd Win’
WHEN Awayteam_win=1
THEN ‘Monton win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division1_results_2017
WHERE AwayTeam = ‘Monton’
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 Leigh A

No Match

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

10/05/2018

Leigh A v Tyldesley

[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 ‘Leigh A Win’
WHEN Awayteam_win=1
THEN ‘Tyldesley win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division1_results_2017
WHERE AwayTeam = ‘Tyldesley’
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]

Ellesmere A v Monton

[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 ‘Ellesmere A Win’
WHEN Awayteam_win=1
THEN ‘Monton win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division1_results_2017
WHERE AwayTeam = ‘Monton’
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]

Roe Green A v Open Week

No Match

David Lloyd v Claremont 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 ‘David Lloyd win’
WHEN Awayteam_win=1
THEN ‘Claremont A win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division1_results_2017
WHERE AwayTeam = ‘Claremont 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]

17/05/2018

Open Week v Ellesmere A

No Match

Claremont A v Roe Green 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 ‘Claremont A Win’
WHEN Awayteam_win=1
THEN ‘Roe Green A win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division1_results_2017
WHERE AwayTeam = ‘Roe Green A’
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]

David Lloyd v Tyldesley

[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 ‘David Lloyd Win’
WHEN Awayteam_win=1
THEN ‘Tyldesley Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division1_results_2017
WHERE AwayTeam = ‘Tyldesley’
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]

Monton v Leigh 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 ‘Monton Win’
WHEN Awayteam_win=1
THEN ‘Leigh A Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division1_results_2017
WHERE AwayTeam = ‘Roe Green A’
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

Monton v Tyldesley

[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 ‘Monton Win’
WHEN Awayteam_win=1
THEN ‘Tyldesley Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division1_results_2017
WHERE AwayTeam = ‘Tyldesley’
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 A v David Lloyd

[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 ‘Leigh A Win’
WHEN Awayteam_win=1
THEN ‘David Lloyd Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division1_results_2017
WHERE AwayTeam = ‘David Lloyd’
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]

Ellesmere A v Roe Green 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 ‘Ellesmere A’
WHEN Awayteam_win=1
THEN ‘Roe Green A’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division1_results_2017
WHERE AwayTeam = ‘Roe Green 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]

Open Week v Claremont A

No Match

31/05/2018 (First round Cup Match)

Ellesmere A v Bye David Lloyd v Tyldesley Roe Green A v Monton Leigh A v Claremont A

07/06/2018

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

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

Open Week v Monton

No Match

Roe Green A v David Lloyd

[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 ‘Roe Green A Win’
WHEN Awayteam_win=1
THEN ‘David Lloyd Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division1_results_2017
WHERE AwayTeam = ‘David Lloyd’
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

Claremont A v Monton

[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 ‘Claremont A Win’
WHEN Awayteam_win=1
THEN ‘Monton Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division1_results_2017
WHERE AwayTeam = ‘Monton’
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]

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

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

Open Week v Tyldesley

No Match

21/06/2018

Leigh A v Claremont 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 ‘Leigh A Win’
WHEN Awayteam_win=1
THEN ‘Claremont A Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division1_results_2017
WHERE AwayTeam = ‘Claremont A’
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 David Lloyd

No Match

Roe Green A v Monton

[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 ‘Roe Green A Win’
WHEN Awayteam_win=1
THEN ‘Monton Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division1_results_2017
WHERE AwayTeam = ‘Monton’
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]

Ellesmere A v Tyldesley

[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 ‘Ellesmere A Win’
WHEN Awayteam_win=1
THEN ‘Tyldesley Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division1_results_2017
WHERE AwayTeam = ‘Tyldesley’
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

David Lloyd Bolton v Ellesmere A (Men) David Lloyd Bolton v Ellesmere A (Ladies) Claremont A v Monton (Ladies) Leigh A v Roe Green (Men)

05/07/2018

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

Leigh A v Open Week

No Match

Monton v David Lloyd

[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 AS `Draw`,( CASE WHEN `hometeam_win`=1
THEN ‘Monton Win’
WHEN Awayteam_win=1
THEN ‘David Lloyd Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division1_results_2017
WHERE AwayTeam = ‘David Lloyd’
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 A v Tyldesley

[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 AS `Draw`,( CASE WHEN `hometeam_win`=1
THEN ‘Roe Green A Win’
WHEN `Awayteam_win`=1
THEN ‘Tyldesley Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division1_results_2017
WHERE AwayTeam = ‘Tyldesley’
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

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

Open Week v Roe Green A

No Match

Claremont A v David Lloyd

[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 ‘Claremont A Win’
WHEN `Awayteam_win`=1
THEN ‘David Lloyd Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division1_results_2017
WHERE AwayTeam = ‘David Lloyd’
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]

Monton v Ellesmere 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 ‘Monton Win’
WHEN `Awayteam_win`=1
THEN ‘Ellesmere A Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division1_results_2017
WHERE AwayTeam = ‘Ellesmere 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

Ellesmere A v Open Week

No Match

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

Tyldesley v David Lloyd

[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 ‘Tyldesley Win’
WHEN `Awayteam_win`=1
THEN ‘David Lloyd Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division1_results_2017
WHERE AwayTeam = ‘David Lloyd’
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 A v Monton

[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 ‘Leigh A Win’
WHEN `Awayteam_win`=1
THEN ‘Monton Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division1_results_2017
WHERE AwayTeam = ‘Monton’
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

Claremont A v Open Week

No Match

Tyldesley v Monton

[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 ‘Tyldesley Win’
WHEN `Awayteam_win`=1
THEN ‘Monton Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division1_results_2017
WHERE AwayTeam = ‘Monton’
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]

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

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

02/08/2018

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

Claremont A v Tyldesley

[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 ‘Claremont A Win’
WHEN `Awayteam_win`=1
THEN ‘Tyldesley Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division1_results_2017
WHERE AwayTeam = ‘Tyldesley’
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]

Monton v Open Week

No Match

David Lloyd v Roe Green 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 ‘David Lloyd Win’
WHEN `Awayteam_win`=1
THEN ‘Roe Green A Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division1_results_2017
WHERE AwayTeam = ‘Roe Green 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

Ellesmere A v David Lloyd

[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 ‘Ellesmere A Win’
WHEN `Awayteam_win`=1
THEN ‘David Lloyd Win’
WHEN `r_off`=1
THEN ‘Rained Off’
WHEN `Draw`=1
THEN ‘Draw’ END) AS Result
FROM division1_results_2017
WHERE AwayTeam = ‘David Lloyd’
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]

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

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

Tyldesley v Open Week

No Match

16/08/2018 (Cup Final)

Leigh A v Ellesmere A (Men) Monton v David Lloyd (Ladies)