<center>
<H2>Browse Stats</H2>
<HR>
<?php
        $host = 'localhost';
        $user = 'wmeckard';
        $passwd = 'CS389';
        $database = 'wmeckard';
        $connect = mysqli_connect($host, $user, $passwd);
        $query = "select NAME, COUNTRY, POINTS_FOR, POINTS_AGAINST, POINT_DIFF, GAMES_PLAYED, AVG_PPG, DEF_TOUCH, SOFT_TOUCH, ACES, WINS, LOSSES, RATIO
 from SPIKE order by AVG_PPG desc";
        mysqli_select_db($connect, $database);
        $result_id = mysqli_query($connect, $query);
        if($result_id)
        {
                print '<table border=1>';
                print '<TH> NAME <TH> COUNTRY <TH> POINTS FOR <TH> POINTS AGAINST <TH> POINT DIFFERENTIAL <TH> GAMES PLAYED <TH> AVG PPG <TH> DEF. TOUCHES <TH> SOFT TOUCHES <TH> ACES <TH> WINS <TH> LOSSES <TH> W/L RATIO';              
                while($row = mysqli_fetch_row($result_id))
                {       print '<TR>';
                        foreach ($row as $field)
                                print "<TD> $field </TD>";
                        print '</TR>';
                }
                print '</table>';
        }
        else
                print "Fail.<p>";
        mysqli_close($connect);
?>
<P><P>
<small>
<A HREF=browseStats.php>Sort by Name</A>|
<A HREF=byACES.php>Sort by Aces</A>|
<A HREF=byDEFTOUCH.php>Sort by Defensive Touches</A>
</small>
<P><P><HR><P>
<A HREF=spikeStats.html>HOME</A>

</center>