nike_guy_man — Tue, 11 Jun 2002 22:46:50 +0000
Here, this should work
<?php
$query = \"SELECT property0202.apn, property0202.lastname, 
property0202.streetnum, property0202.street, 
exclude2002.apn FROM property0202, exclude2002 
WHERE property0202.apn LIKE '$apn%' 
AND property0202.streetnum LIKE '$streetnum%' 
AND property0202.street LIKE '$street%' 
AND property0202.lastname LIKE '$lastname%' 
AND property0202.apn = exclude2002.apn 
ORDER BY property0202.apn, property0202.lastname, 
property0202.streetnum, property0202.street\";

$result = mysql_query($query) or die(mysql_error());
$num = mysql_num_rows($result);
if ($num > 0) {
while ($row = mysql_fetch_array ($result)) {
    sprintf (
    \"<table>
    <tr>
    <td>APN</td>
    <td>LAST NAME</td>
    <td>STREET NUMBER</td>
    <td>STREET NAME</td>
    </tr>    
    <tr>
    <td>     %s     </td>
    <td>     %s      </td>
    <td>     %s     </td>
    <td>     %s     </td>
    </tr></table>\n\", 
    $row[0], $row[1], $row[2], $row[3]);
}    
} else {
print \"No Records Found\";
}
?>
That should work