Mark Hensler — Tue, 23 Jul 2002 17:06:27 +0000
try something like this
<?php
function Query_Error($file, $line, $query, $silent=TRUE) {
    
    echo \"\n\n\";
    echo ($silent == TRUE) ? \"<!--\n\" : \"<textarea cols=\\"60\\" rows=\\"7\\">\n\";
    echo \"FILE: $file\n\";
    echo \"LINE: $line\n\";
    echo \"\n\";
    echo \"QUERY ERROR:\n\";
    echo mysql_error() . \"\n\";
    echo \"\n\";
    echo \"QUERY:\n\";
    echo $query . \"\n\";
    echo ($silent == TRUE) ? \"-->\n\" : \"</textarea>\n\";
    echo \"\n\n\";
    
}



mysql_connect (localhost, login, \"pass\");
mysql_select_db (remediation);

if ($apn == \"\") {
    $apn = '%';
}


$query = \"SELECT * FROM excluded WHERE apn='$apn%'\";
$result = mysql_query ($query);
if (!$result) {
    Query_Error(__FILE__, __LINE__, $query);
}

if ($result && mysql_num_rows($result) > 0) {
    print \"Sorry, that number has been excluded.\";
}
else {
    
    $query = \"SELECT bills02.co, bills02.apn, bills02.ann, bills02.fee, bills02.contam\"
            .\" FROM bills02\"
            .\" WHERE bills02.apn='$apn%'\";
    $result = mysql_query ($query);
    if (!$result) {
        Query_Error(__FILE__, __LINE__, $query);
    }
    
    if ($result && mysql_num_rows($result) == 0) {
        print \"Sorry, no records were found!\";
    }
    
    while ($result && $row=mysql_fetch_array($result)) {
        print (\"<h5>APN (Parcel Number)</h5>\");
        print $row[\"apn\"];
        print (\"<p>Annualized Water Bill</p>\");
        print $row[\"ann\"];
        print (\"<h2>Remediation Fee</h2>\");
        print $row[\"fee\"];
        print (\"<p>Contaminated?</p>\");
        print $row[\"contam\"];
        print (\" \");
    }
    
}
?>