Mark Hensler — Tue, 14 May 2002 20:22:19 +0000

Your parenthesis are not paired either.

Because the error is on the first print statement, I know that the error was caused by the quotes.

try this:

<?php
 

mysql_connect (localhost, remeed, typethis);
   
mysql_select_db (remediation);

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

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

$query = \"SELECT property0202.apn, property0202.streetnum, property0202.street, property0202.lastname\"
        .\" FROM property0202, exclude2002\"
        .\" WHERE (\"
            .\" (property0202.apn = exclude2002.apn)\";
if ($apn != \"\") {
    $query .= \" OR property0202.apn LIKE '$apn%')\";
}
if ($streetnum != \"\") {
    $query .= \" OR property0202.streetnum LIKE '$streetnum%')\";
}
if ($street != \"\") {
    $query .= \" OR property0202.street LIKE '$street%')\";
}
if ($lastname != \"\") {
    $query .= \" OR property0202.lastname LIKE '$lastname%')\";
}

$result = mysql_query($query);

if (!$result) {
  print \"Sorry, no records were found!\";
}

while ($row=@mysql_fetch_array($result)) {
  print $row[\"apn\"];
  print (\" \");
  print $row[\"streetnum\"];
  print (\" \");
  print $row[\"street\"];
  print (\" \");
  print $row[\"lastname\"];
  print (\"<p>\");
}
?>

Making mySQL search a field for a wildcard increases the load, just omit that field.

getyourbiglobst — Tue, 14 May 2002 05:39:38 +0000

in the original code i had the " " in the right place (must have pasted wrong).

i'm still getting the error on line 34, which is the 1st line of my print statement. i can't understand why this is happening.

thanks for your time.

Mark Hensler — Tue, 14 May 2002 02:46:11 +0000

Forgot to close the quotes around your SQL statement.