The below program displays the record selected but I need to know how to use that table to update fields in it? In other words if the table that is displayed was input fields and I could then update the database?
<form method="post" action="selectapt.php">
<br/>
<input type="varchar" name="apt"/><br/><br/>
<input type="submit" name="submit" value="Select Apartment for Payment"/> </form>
<?php
$apt = $_POST['apt'];
$username="root";
$password="";
$database="prerentdb";
mysql_connect(localhost,$username,$password);
mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM payments Where apt='$apt'";
$result=mysql_query($query);
$num=mysql_numrows($result);
echo "<b><center>Prerent Report</center></b><br><br>";
echo "<table border='1'>
<tr>
<th>dep</th>
<th>apt</th>
<th>tenant</th>
<th>month</th>
<th>prev</th>
<th>misc</th>
<th>rent</th>
<th>hud</th>
<th>tenant</th>
<th>amt</th>
<th>date</th>
<tr>
<th colspan=2>num</th>
<th>name</th>
<th>chg</th>
<th>bal</th>
<th>amt</th>
<th>due</th>
<th colspan=2>pay</th>
<th colspan=2>paid</th>
</tr>";
while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['dep'] . "</td>";
echo "<td>" . $row['apt'] . "</td>";
echo "<td>" . $row['name'] . "</td>";
echo "<td>" . $row['rent'] . "</td>";
echo "<td>" . $row['prevbal'] . "</td>";
echo "<td>" . $row['misc'] . "</td>";
echo "<td>" . $row['rentdue'] . "</td>";
echo "<td>" . $row['hudpay'] . "</td>";
echo "<td>" . $row['tentpay'] . "</td>";
echo "<td>" . $row['amtpaid'] . "</td>";
echo "<td>" . $row['datepaid'] . "</td>";
echo "</tr>";
}
echo "</table>";
mysql_close();
?>
Linear Mode
