<CENTER>
<?php
	//  resulthw5.php

	$course = $_POST['course'];

	$host = 'localhost';
	$user = 'anclark';
	$passwd = 'cs389';
	$database = 'anclark';

	$connect = mysqli_connect($host, $user, $passwd);
	$query = "select GENDER, GRADE, LECT_PREP, STU_PART, OVERALL  from EVALUATION where COURSE='$course' ";
//	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> GENDER <TH> GRADE <TH> LECT_PREP <TH> STU_PART <TH> OVERALL ';
		while($row = mysqli_fetch_row($result_id))
		{	print '<TR>';
			foreach ($row as $field)
				print "<TD> $field </TD> ";
			print '</TR>';
		}
	}
	else
		print "Fail.<p>";
	mysqli_close($connect);
?>
</CENTER>

<center><P>
<A HREF=index.html> HOME </A> | <A HREF=evalformhw5.html> FORM </A>
<P>
</center>