<!--
    	P.61 display.php

-->

<center>
<H2>Display Table</H2>
<HR>
<?php
     	$host = 'localhost';
        $user = 'rkelly';
        $passwd = 'CS389';
        $database = 'rkelly';
        $connect = mysql_connect($host, $user, $passwd);
        $query = "select * from EVALUATION";
//	print "The query is <i> $query </i> ";
        mysql_select_db($database);
        $result_id = mysql_query($query, $connect);
        if($result_id)
        {
                print '<table border=1>';
                print '<TH> GENDER <TH> GRADE <TH> COURSE <TH> LECTURE <TH> STUDENT PREP <TH> OVERALL';
                while($row = mysql_fetch_row($result_id))
                {	print '<TR>';
                        foreach ($row as $field)
                                print "<TD> $field </TD> ";
                        print '</TR>';
                }
                print '</table>';
        }
	else
            	print "Fail.<p>";

        mysql_close($connect);
?>
</center>
<center> <A HREF=Assignment5.html> HOME </A> | <A HREF=evaluationForm.html> FORM </A>
</center>