Jump to content


Photo

sql query problems


  • Please log in to reply
1 reply to this topic

#1 adult.swim

adult.swim
  • New Members
  • Pip
  • Newbie
  • 6 posts

Posted 04 October 2006 - 03:15 AM

I have created a html form page, and a corresponding process page.

My form gets input from the user, and compares it to the fields in my database. If the input

in the form matches a field in the dB, the process page returns the corresponding record.

The problem is only the address input for the form works correctly. All of the other fields

return all the records in the dB. I've tried varying the SQL query code many times.

My question is why does only the address search work as opposed to the other input fields?

search.php: form


<form id=\"search\" method=\"post\" action=\"process.php\">

<table class=\"search1\">

<tr>
<th><label for=\"pad\">Pad Number</label></th>
<td><input id=\"pad\" name=\"pad\" type=\"text\" class=\"inputbox\" size=\"50\" /><br 

/></td>
</tr>

<tr>
<th><label for=\"mls\">MLS Number</label></th>
<td><input id=\"mls\" name=\"mls\" type=\"text\" class=\"inputbox\" size=\"50\" /><br 

/></td>
</tr>

<tr>
<th><label for=\"address1\">Address</label></th>
<td><input id=\"address1\" name=\"address1\" type=\"text\" class=\"inputbox\" size=\"100\" 

/><br /></td>
</tr>

<tr>
<th><label for=\"city\">City</label></th>
<td><input id=\"city\" name=\"city\" type=\"text\" class=\"inputbox\" size=\"100\" /><br 

/></td>
</tr>

<tr>
<th><label for=\"zip\">Zip Code</label></th>
<td><input id=\"zip\" name=\"zip\" type=\"text\" class=\"inputbox\" size=\"15\" /><br 

/></td>
</tr>


</table>

<br />

<table class=\"search2\">

<tr>
<td>

<input type=\"Submit\" value=\"Submit\" style=\"width: 60px; font-size: 1.0em; padding: 2px 

10px 2px 10px; margin: 5px 3px -3px 3px; background-color: #115492; float: left; border: 

solid 1px #023666; color: #ffffff; text-decoration: none;\" />

<input type=\"Reset\" value=\"Reset\" style=\"width: 60px; font-size: 1.0em; padding: 2px 

10px 2px 10px; margin: 5px 3px -3px 3px; background-color: #115492; float: left; border: 

solid 1px #023666; color: #ffffff; text-decoration: none;\" />

<input type=\"hidden\" name=\"op\" value=\"do\" /><p>&nbsp;</p>
</td>
</tr>
</form>

</table>


---------------------------------------------
process.php:

<? 
# connect to a DSN "mydb" with a user and password "marin" 
$connect = odbc_connect("**", "**", "**");

# query the users table for name and surname
$query = "SELECT * FROM props WHERE props.MLSnumber='$mls' 
OR props.Pads LIKE '%$pad%'
OR props.Address LIKE '%$address1%'
OR props.City='$city'
OR props.Zip='$zip'";

# perform the query
$result = odbc_exec($connect, $query);

//output results to standard output 
//odbc_result_all($result, "BORDER=1"); 

# fetch the data from the database
while(odbc_fetch_row($result)){
  $mls = odbc_result($result, 2);
  $address = odbc_result($result, 5);
  $pad = odbc_result($result, 16);
  $city = odbc_result($result, 7);
  $zip = odbc_result($result, 9);
  $check = odbc_result($result, 17);
//  print("$mls  $address  $pad  $city  $zip");
  
  //format results 
    print ("<tr>"); 
    print ("<td>$pad</td>"); 
    print ("<td>$mls</td>"); 
    print ("<td>$address</td>"); 
	print ("<td>$city</td>");
	print ("<td>$zip</td>");
	print ("</tr>"); 
    } 

# close the connection
odbc_close($connect);
?>



#2 sasa

sasa
  • Staff Alumni
  • Advanced Member
  • 2,804 posts
  • LocationHrvatska

Posted 05 October 2006 - 09:38 PM

expresion some_field LIKE '%%' is always true




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users