<!-- 
        Corey Gray
        CS 480
        DUE: March 31, 2014
        Use mysql to make a table
        then show it on a webpage  
-->

<center>
<font size = 5 color = green>
<?php
	print "Database Table.";

	$host = 'localhost';
	$user = 'cngray';
	$passwd = 'vwccscngray';
	$database = 'cngray';

	$connect = mysql_connect($host, $user, $passwd);
	$query = "select * from STUDENT";
	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> ID <TH> NAME <TH> SCORE';
		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);
?>
</font>
</center>