<!-- search.php -->

<?php
	

	$ID = $_POST['id'];

	$host = 'localhost';
	$user = 'dmhoward';
	$passwd = 'vwccsdmhoward';
	$database = 'dmhoward';

		
	$connect = mysql_connect($host, $user, $passwd);
	$query = "select * from STUDENT where ID=$ID";
	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);
?>