<!--
        Ash Dobrenen
        Minecraft Survey Project
        MS12Display.php
-->

<CENTER>
<H2>
Here is your ranking of the other users who would be complementary to you. 
<P>(Results are ranked by your top task in ascending order, so your result is at the bottom,
and players who like different tasks are at the top to help you find diverse players)
</H2>

<?php
	$build = $_SESSION['build'];
        $mine = $_SESSION['mine'];
        $fight = $_SESSION['fight'];           
        $red = $_SESSION['red'];

	if($build == 4)
		$top = 'BUILD';
	if($mine == 4)
                $top = 'MINE';
	if($fight == 4)
                $top = 'FIGHT';
 	if($red == 4)
                $top = 'REDSTONE';

	$host = 'localhost';
        $user = 'akdobrenen';
        $passwd = 'CS389';
        $database = 'akdobrenen';
        $connect = mysqli_connect($host, $user, $passwd);
        $query = "select * from 12SURVIVAL ORDER BY $top;";
//      print "The query is <i> $query </i> ";
        mysqli_select_db($connect, $database);
        $result_id = mysqli_query($connect, $query);
        if($result_id)
        {
                print '<table border=1>';
                print '<TH> USERNAME <TH> AGE <TH> BUILD <TH> MINE <TH> FIGHT <TH> 
			REDSTONE <TH> FAV';
                while($row = mysqli_fetch_row($result_id))
                {       print '<TR>';
                        foreach ($row as $field)
                                print "<TD> $field </TD> ";
                        print '</TR>';
                }
                print '</table>';
        }
        else
                print "Fail 12Display.<p>";

        mysqli_close($connect);
?>
<HR>

<A HREF=MSHomePage.php> Minecraft Survey Home | <A HREF=index.html> Main Page

</FORM>
</CENTER>