<!---
        Corey Gray 
        CS 480
        DUE: April 7, 2014
        Have a page with two links
                first link will have an input page for information to the table
                second link will show the table with updated information
-->

<?php
	$course = $_POST['course'];
        $gender = $_POST['gender'];
        $grade = $_POST['grade'];
	$q1 = $_POST['q1'];
	$q2 = $_POST['q2'];
	$q3 = $_POST['q3'];
        $host = 'localhost';
        $user = 'cngray';
        $passwd = 'vwccscngray';
        $database = 'cngray';
        $connect = mysqli_connect($host, $user, $passwd);
        $query = "select * from INFO";
        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> COURSE <th> GENDER <th> GRADE <th> QUESTION 1 <th> QUESTION 2 <th> QUESTION 3';
		while ($row = mysqli_fetch_row($result_id))
		{
			print '<tr>';
			foreach ($row as $field)
				print "<th> $field </th> ";
			print '</th>';
		}
	}
	else
		print "Fail.<p>";

	mysqli_close($connect);
?>