<?phpmysql_connect(localhost,root,"");mysql_select_db(maintdb) or die( "Unable to select database");if(!empty($_POST["submit"])){ $compmo = $_POST['compmo'];$query="SELECT * FROM maintdata Where compmo='$compmo'";$result=mysql_query($query);if(mysql_num_rows($result)){ echo "<form action='#' method='post'><b>Poject: Maintenance Log</b><br /><br />;echo "<table cellspacing=1 cellpadding=1 border='0'><tr> <TH>Apt</TH> <TH>Name</TH> <TH>Received</TH> <TH>Time</TH> <TH>Problem</TH> <TH>Correction</TH> <TH colspan=3>Finished</TH> <TH>Ord#</TH> </tr>";while($row = mysql_fetch_array($result)){echo "<tr>";echo "<td>" . $row['apt'] . "</td>";echo "<td>" . $row['name'] . "</td>";echo "<td>" . $row['datereceived'] . "</td>";echo "<td>" . $row['time'] . "</td>";echo "<td>" . $row['symptom'] . "</td>";echo "<td>" . $row['action'] . "</td>";echo "<td>" . $row['compmo'] . "</td>";echo "<td>" . $row['compday'] . "</td>";echo "<td>" . $row['compyear'] . "</td>";echo "<td>" . $row['ordno'] . "</td>";echo "</tr>";}echo "</table>mysql_close();?><form method="post" action="#"> <br /> <input type="text" name="compmo"/> <p><input type="submit" name="submit" value="select maintenance month"/></form>
echo "<form action='#' method='post'><b>Poject: Maintenance Log</b><br /><br />;
echo "<form action='#' method='post'><b>Poject: Maintenance Log</b><br /><br />";