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>