Junior County Team

North Midlands junior county crown green bowls team 2014

North Midlands junior county crown green bowls team 2014

We have a very active junior county team, supported by loads of junior competitions running from May to September each year. In 2015 a new Academy was formed to attract new young players to the game, and to help them develop through to county status.

With the introduction of the League system in 2018, A county fixture involves 10 junior players playing at home and 10 playing at an away venue with the team selected by the Junior County committee.

Full details of the Junior County Championship can be viewed here.

We also run coaching sessions for novice and experienced junior bowlers. Details can be found at www.playcrowngreen.org.

[insert_php]Global $league, $year; $league = 3; $year = 2018; [/insert_php]

[insert_php]
Global $insert, $league, $year;
if($year !== “”) { $insert = “where homefor is not null and oidleague = $league and EXTRACT(YEAR FROM matchdate) = $year”; }
[/insert_php]


[insert_php]
Global $insert, $league;
try
{
$dbh = new PDO(getConnString(), getUser(), getpw());
#$dbh->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );

if($league> 0)
{
$teamQ =$dbh->Query( “SELECT day from league where oidleague = $league”);
$team = $teamQ->fetch();
echo(“

“.$team[‘day’].”

“);
}

$sql = “SELECT oidcountymatches, matchdate as \”Date\”,opponent as \”Opponent\”,homefor+awayfor as \”For\”,homeopp+awayopp as \”Against\”,overallresult as \”Result\”, isincomplete, notes, issupplemental FROM countymatches $insert order by matchdate desc”;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
foreach ($dbh->query($sql) as $row)
{
$date = date(“jS F Y”, strtotime($row[‘Date’]));
$oidCM = $row[‘oidcountymatches’];
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
if($row[‘isincomplete’] == true) { echo “

“; }
else { echo “

“; }
echo “

“;
}
echo “

DateOpponentFA
“.$date.”“.$row[‘Opponent’];
if(!is_null($row[‘notes’]))
{
echo ” (“.$row[‘notes’].”)”;
}
if($row[‘issupplemental’] == true)
{
echo ” *”;
}
$incomplete = $row[‘isincomplete’] == true;
if($incomplete) { echo ” #”; }
echo”
“.$row[‘For’].”“.$row[‘Against’].”“.$row[‘Result’].”

“;
$dbh= null;
echo “

# incomplete results held, * Supplemental match

“;
}
catch(PDOException $e) { echo $e; }
[/insert_php]


Full(ish) history of results can be viewed here.

[insert_php]
function getPlayerLink($player)
{
return “$player“;
}

Global $league;
try
{
$mode = $_GET[“mode”];
if(is_null($mode)) { $mode = “Aggregate”; }
$dbh = new PDO(getConnString(), getUser(), getpw());
$dbh->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
if($league !== null) {$sqlTeams = “SELECT oidleague, day as \”Team\” FROM league where oidleague = $league”;}
else {$sqlTeams = “SELECT oidleague, day as \”Team\” FROM league where oidleague <> 1″;}
foreach ($dbh->query($sqlTeams) as $rowTeam)
{
echo “

“.$rowTeam[‘Team’].” Top Stats

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;

$mod = “rowEven”;
$oidleague = $rowTeam[‘oidleague’];
$sqlPlayers = “SELECT * FROM playerstats WHERE oidleague = $oidleague and played >= 5 ORDER BY $mode DESC limit 10”;
foreach ($dbh->query($sqlPlayers) as $rowStats)
{
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
if($mod == “rowEven”) { $mod = “rowOdd”; }
else { $mod = “rowEven”; }
}
echo “

PlayerPldW%WonFirstLastAgg
“.getPlayerLink($rowStats[‘homeplayer’]).”“.$rowStats[‘played’].”“.round($rowStats[‘wp’],1).”%“.$rowStats[‘won’].”“.date(“jS M Y”, strtotime($rowStats[‘firstplayed’])).”“. date(“jS M Y”, strtotime($rowStats[‘lastplayed’])).”“.$rowStats[‘aggregate’].”

“;
}
$dbh = null;
}
catch(PDOException $e) { echo $e; }
[/insert_php]