<?php   session_start();        ?>

<!--  p

File name: searchInput.php

search for the author here

-->

<?php

         $pass = $_SESSION['password'];
        if($pass != "password")  print "Go away.";
        else
        {
?>


<CENTER>
<H2>
Author Display
</H2>
<HR>
<Font color=black size=4>



<?php


	$author = $_POST['author'];

	$host = 'localhost';
	$user = 'crsterling';
	$passwd = 'CS389';
	$database = 'crsterling';

	$connect = mysql_connect($host, $user, $passwd);
	$query = "select USER, BOOKNAME, AUTHOR from BOOKDRIVE where AUTHOR='$author' ";
	

	mysql_select_db($database);
	$result_id = mysql_query($query, $connect);

	if($result_id)
	{
		print '<table border=1>';
		print '<TH> USER <TH> BOOKNAME <TH> AUTHOR  ';
		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);













?>




</CENTER>



<?php
        }
?>