how do I show to search all in a certain field

gatorwire

I have a search form to query a database of new homes.

I am setting up the form to have drop down menus and I wanted to have the option for viewers to search by any.

such as.....

what value do I put in the form under the any option?

and how should it be put in the search.php page...

mysql_connect("localhost","gatorw56_gator","scream");

mysql_select_db("gatorw56_homesearch");

$search=$_GET["models,bed,bath,garage"];

$bedrooms = $POST['bed'];
$bath = $POST['bath'];
$garage = $_POST['garage'];

$result = mysql_query("SELECT * FROM homes WHERE models LIKE '%$search%' AND bed = '".$bed."' AND garage = '".$garage."' AND bath = '".$bath."'");

while($r=mysql_fetch_array($result))
{

$models=$r["models"];
$bed=$r["bed"];
$bath=$r["bath"];
$garage=$r["garage"];
$sqft=$r["sqft"];
$id=$r["id"];

echo "models:$models bed: $bed bath: $bath garage: $garage sqft: $sqft ";

}
?>

when I search by any now it brings up a blank white screen.

rachel2004

In place of * in your <select> menu, you could use something like "any" as an option value. Then in your PHP code, you could use a series of "if" statements to check for it:

<?php 

$sql = "SELECT * FROM homes WHERE models LIKE '%$search%'";
if ($_POST['bed'] != "any") {
	$sql .= " AND bed = '".$bed."'";
}

if ($_POST['bath'] != "any") {
	$sql .= " AND bath = '".$bath."'";
}

// you could do this for each desired feature of a property; you get the point.

$result = @mysql_query($sql, $link)
	// in your production code, do not use mysql_error(), but for development, go ahead:
	or die("<p>Couldn't execute query: <strong>".mysql_error()."</strong></p>");

?>

The code above has no error-checking, so don't use it as is, okay?

gatorwire

thank you so much.

it works great!!!!

rachel2004

You're very welcome. Best to you on the project.