<Font color=blue size=4>
Display the table content
<P>
<?php
	$host = 'localhost';
	$user = 'jtbegley';
	$passwd = 'cs480';
	$database = 'jtbegley';

	$connect = mysql_connect($host, $user, $passwd);
	$table_name = 'inventory';

	// p.172
	$query = "select * from inventory";
	// debug
	print "The query is <i> $query </i> ";

	mysql_select_db($database);

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

	if($result_id)
	{	// p.175 line 16
		print '<table border=1>';
		print '<TH> Name <TH> Cost <TH> Sale Price <TH> Number Sold 
<TH> Number in inventory';
		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>