WHERE league = 'A'
GROUP BY draftedFrom
ORDER BY nbr DESC
</pre>
</header>
<?php
$connection = new DB_Class();
?>
<?php
$connection->connect();
?>
<?php
$query = "\nSELECT draftedFrom, COUNT(*) as nbr \nFROM Draft \nWHERE league = 'A' \nGROUP BY draftedFrom \nORDER BY nbr DESC";
?>
<p><?php
echo $connection->count_results($query);
?>
results found.</p>
<?php
$data = $connection->fetch($query);
?>
<table class="table table-striped">
<thead>
<tr>
<th>Firstname</th>
<th>Lastname</th>
</tr>
</thead>
<tbody>
<?php
foreach ($data as $row) {
</ul>
<div class="tab-content">
<div class="tab-pane active" id="player">
<!-- Search for Player info -->
<?php
$query = "SELECT p.pid, p.firstName, p.lastName, p.college, p.birthdata\n FROM Player p\n WHERE p.firstName LIKE '%" . $keyword . "%'\n OR p.lastName Like '%" . $keyword . "%' \n OR p.college Like '%" . $keyword . "%'\n OR p.pid LIKE '%" . $keyword . "%' ";
?>
<?php
// Fetch results of query
?>
<?php
$data = $connection->fetch($query);
?>
<div class="page-header">
<h1>Player <small><?php
echo $connection->count_results($query) . " Results";
?>
</small></h1>
</div>
<table class="table table-striped">
<thead>
<tr>
<th>ID</th>
<th>Firstname</th>
<th>Lastname</th>
<th>College</th>
<th>Birthdata</th>
<th>Remove</th>
<th>Show more</th>
</tr>
</thead>
