databse search help

Anon

hello-

i am getting this error-
::::::::::::
Parse error: parse error, expecting T_STRING' orT_VARIABLE' or `T_NUM_STRING' in /web/eww/remediation/htdocs/multi_query.php on line 34
:::::::::::
line 34 is ---> do {
print $row["apn"];
:::::::::::
i can't figure out what's going on.

thanks for your time.

<?php

mysql_connect (localhost, remeed, typethis);

mysql_select_db (remediation);

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

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

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

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

$result = mysql_query("SELECT property0202.apn, property0202.streetnum,
property0202.street, property0202.lastname
FROM property0202, exclude2002
WHERE ((property0202.apn LIKE '$apn%')
OR (property0202.streetnum LIKE '$streetnum%')
OR (property0202.street LIKE '$street%')
OR (property0202.lastname LIKE '$lastname%')
OR (property0202.apn = exclude2002.apn));

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

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

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

tomhath

You never closed the double quote from the mysql_select 12 lines up

Anon

yeah, i just noticed that, but in my original code the quote was closed. anyway, i'm still getting the error on line 34 (first line of my print statement). any ideas as to why this is happening?

thanks for your time.

Anon

Hallo J,

I have seen two syntax errors.

1 You haven't closed the opening bracket of "mysql_query".
2 Before closing the above bracket, there should be " mark.

Solomon

Anon

this database query seems to be working, but perhaps there is an easier or more logical way of doing it.

the script is supposed to pull APN, LASTNAME, STREETNUM, and STREET from the PROPERTY table if the variables match the form entries, AND if property0202.apn = exclude2002.apn

does this seem right to you?

also, how can i make it display some message if nothing is found? right now it just show the blank html page.

<?php

mysql_connect (localhost, remeed, typethis);

mysql_select_db (remediation);

$query = "SELECT property0202.apn, property0202.lastname,
property0202.streetnum, property0202.street
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 ("Query Failed");
while ($row = mysql_fetch_array ($result))
{
printf (
"<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]);

}
?>

Anon

$result = mysql_query($query);
//Count the number of rows in $result

$count = mysql_num_rows($result);
If($count = 0){
echo "Sorry, you query returns nothing!!!";
}

Solomon

Anon

i changed it, but now it is not returning anything. no errors, just a blank html page. i'll try messing arround with the placement of the code you gave me.

any ideas? thanks.

$query = "SELECT property0202.apn, property0202.lastname,
property0202.streetnum, property0202.street
FROM property0202, exclude2002
WHERE ((property0202.apn = '$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);

$count = mysql_num_rows($result);
If($count = 0) {
echo "sorry, nothing returned";
}

while ($row = mysql_fetch_array ($result))
{
printf (
"<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]);

}
?>