chequedet.php

<?php
$con=mysqli_connect("localhost", "root", "") or die("Connection Failed");
mysqli_select_db($con,"practice")or die("Connection Failed");
$query = "select b.houseno,b.resname,m.phone1,b.chequeno,b.amount,b.amount-12500 dueamt from billing b,malaysiantownship m where b.cash!='Y' AND m.houseno=b.houseno";
$result = mysqli_query($con,$query) or die(mysql_error()); 
print " 
<table border=\"5\" cellpadding=\"5\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#000000\" width=\"100&#37;\" id=\"AutoNumber2\" bgcolor=\"#FFF8DC\"><tr> 

<td width=100>House No:</td> 
<td width=100>Resident Name:</td>
<td width=100>Phone Number:</td>
<td width=100>Cheque No:</td>
<td width=100>Cheque Amount:</td> 
<td width=100>Due Amount:</td> 

</tr>"; 

while ($row = mysqli_fetch_array($result, MYSQL_ASSOC)) {

print "<tr>"; 
 
print "<td>" . $row['houseno'] .  "</td>"; 
print "<td>" . $row['resname'] . "</td>";
print "<td>" . $row['phone1'] . "</td>";
print "<td>" . $row['chequeno'] . "</td>";
print "<td>" . $row['amount'] . "</td>";
print "<td>" . $row['dueamt'] . "</td>";
print "</tr>"; 
}
print "</table>"; 
?>