<!--	
	Denisha Howard
	Assignment 5 (Home Project)
	CS 480
	Goal: Write the SQL script that includes SQL
	commands to create a table,EVALUATION
	and insert records (at least three)
	to the table. On the MySQL console, run the 
	script to create the table.
-->
<CENTER>
<?php
        $host = 'localhost';
        $user = 'dmhoward';
        $passwd = 'vwccsdmhoward';
        $database = 'dmhoward';

        $connect = mysql_connect($host, $user, $passwd);
        $query = "select * from EVALUATION";
	print "COURSE EVALUATION<P>";
        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> LECT_PART 
<TH> STU_PART <TH> OVERALL';
                while($row = mysql_fetch_row($result_id))
                {
                        print '<TR>';
                        foreach($row as $field)
                                print "<TD> $field </TD>";
                        print '</TR>';
                }
        }
        else
                print "Fail. <p>";
        mysql_close($connect);
?>