<?php
error_reporting(E_ALL);
@@ ini_set('display_errors', 1);

//Include database connection details
require_once('../loggedIN/config.php');

//Connect to mysql server
$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
if(!$link) {
    die('Failed to connect to server: ' . mysql_error());
}

//Select database
$db = mysql_select_db(DB_DATABASE);
if(!$db) {
    die("Unable to select database");
}

$count = 1;

function mixed() {

    $qry =  "SELECT firstName, lastName, avgPPT " .
            "FROM bowlers " .
            "ORDER BY avgPPT ASC " .
            "LIMIT 0, 10";
    $result = mysql_query($qry);
    if (!$result) {
        die("FAIL!");
    }

    while($row = mysql_fetch_array($result)) {
        echo "<tr>";
        echo "<td>" . $count . "</td>";
        echo "<td>" . $row['firstName'] . "</td>";
        echo "<td>" . $row['lastName'] . "</td>";
        echo "<td>" . $row['avgPPT'] . "</td>";
        echo "</tr>";
        $count++;
    }
    return;
}
?>