dbase search help

[Anon]

my code works, but i want it to do more. currently it returns all information in one dbase (bills02) based on user input from an html form.

what i want to be able to do is have the user input a number(apn) and have the php search one table(excluded) in the database and if their number is found print a message(your apn is excluded). if their number is not found, then it is goes and searches the other table in the database (bills02) and displays the relevant information (what it basically does not).

i appreciate your thoughts on this.
phpcode\\\\\\\

mysql_connect (localhost, remeed, "i8@home");

mysql_select_db (remediation);

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

$result = mysql_query ("SELECT bills02.co, bills02.apn, bills02.ann, bills02.fee, bills02.contam
FROM bills02
WHERE bills02.apn = '$apn%'
");

if ($row = mysql_fetch_array($result)) {

do {
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 (" ");

} while($row = mysql_fetch_array($result));

} else {print "Sorry, no records were found!";}

?>

[bastien]

Hi jb,

okay, one assumption, user MUST include the apn

<?//db declarations here - connection table etc)

$sql="select * from mytable where apn=$apn";

$result=$mysql_num_rows($sql) or die ("could not execute apn search");

if ($result == 1){
echo "Your APN is excluded";
}else if ($result == 0){
$sql2 = "select * from bills02";
$result2 = mysql_query($sql2) or die ("could not process bills table query");
while ($row = mysql_fetch_array($results2){
$apn = $row["apn"];
$ann = $row["ann"];
$fee = $row["fee"];
$con = $row["contam"];

print ("<h5>APN (Parcel Number)</h5>"); 
print $apn;
print ("<p>Annualized Water Bill</p>"); 
print $ann; 
print ("<h2>Remediation Fee</h2>"); 
print $fee; 
print ("<p>Contaminated?</p>"); 
print $con; 
print (" "); 

}

hth

bastien

[Anon]

i'm getting an error on this line::::
while ($row = mysql_fetch_array($results2){
::::::
Parse error: parse error, unexpected '

any ideas?
thanks.