the search will only search everything...

gatorwire

Here is my query script.....

http://www.gatorwire.com/query.html

here is the search form.....

http://www.gatorwire.com/page/

I can't get the search form to pull up just certain parameters like 2 beds or 2 baths. When I do select them it searches everything.

what do I need to change?

mourisj

In the first part you do all these:

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

etc.

However, your $sql is not yet set !!
So, when you do in the middle:

$sql = "SELECT * FROM homes WHERE models LIKE '%$search%' LIMIT $offset, $rowsPerPage";

all your previous "AND bed ..." are gone.

Put the $sql = ... before you define your conditions, and things should work fine.

Hint: for test purposes, echo() your $sql just before mysql_query()ing it to see if it looks like it should.

JJ Mouris

gatorwire

Originally posted by mourisj
In the first part you do all these:

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

etc.

However, your $sql is not yet set !!
So, when you do in the middle:

$sql = "SELECT * FROM homes WHERE models LIKE '%$search%' LIMIT $offset, $rowsPerPage";

all your previous "AND bed ..." are gone.

Put the $sql = ... before you define your conditions, and things should work fine.

Hint: for test purposes, echo() your $sql just before mysql_query()ing it to see if it looks like it should.

JJ Mouris

could you write out the code to show me how it should be setup.

I need to get this up and running quickly.

If you or anyone can help with this code to make it work fast, I will pay.

I need it badly!!!!!!!

mourisj

As I said: simply put the basic $sql before you concatenate your AND clauses:

(Note: no guarantee about all the rest of your code, though !!)

(...)
// counting the offset
$offset = ($pageNum - 1) * $rowsPerPage;

//put your initial $sql here

$sql = "SELECT * FROM homes WHERE models LIKE '%$search%' LIMIT $offset, $rowsPerPage";

//leave the rest unchanged

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

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

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

$price_upper_bound = $_POST['price'];
switch($price_upper_bound) {
case "any":
$range = "";
break;

case "0":
$range = " AND (price >= 0) AND (price <= 50000)";
break;

case "1":
$range = " AND (price > 50000) AND (price <= 150000)";
break;

case "2":
$range = " AND (price > 150000) AND (price <= 200000)";
break;

case "3":
$range = " AND (price > 200000) AND (price <= 250000)";
break;

case "4":
$range = " AND (price > 250000) AND (price <= 300000)";
break;

default:
$range = "";

}
$sql .= $range;

// $sql=... has been removed from here

$result = @($sql)

or die("<p>Couldn't execute query: <strong>".mysql_error()."</strong></p>");
//exit php tag to include table opening here

(...)