<A HREF = PUPadminLogin.html>Back to Employee Login</A>
<p>
<A HREF = PUPShome.html> Back To PUPS Main Page</A>
<CENTER>
<?php
	// p.63 search.php

	$first = $_POST['first'];

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

	$connect = mysqli_connect($host, $user, $passwd);
	$query = "select LAST, EMAIL from CLIENTS where FIRST='$first' ";
	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> LAST <TH> EMAIL ';
		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>