Jump to content

Need help displaying search results


tom11011

Recommended Posts

Hi all, I have a form that I use that posts to a php page.  I use mysql as my backend.

I am having trouble figuring out how I should query and display the results.  My criteria are as follows:

My searchable fields include type, state, city, zip, pricemin, pricemax, squarefeetmin, and squarefeetmax.
The field name for pricemin and pricemax is price.
The field name for squarefeetmin and squarefeetmax is squarefeet.

type and state are required fields.  The other fields are not required to be entered, but if they are, I would like the search narrowed on that criteria.

Could someone help me with my code?  I have gotten as far as running the query based on the required fields, but don't know how best to show the data based on the other non-required fields.  Here is my code.

[code]
<?PHP session_start(); ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<title>Search Results</title>
</head>
<body>

<?PHP
mysql_pconnect("10.1.1.35", "test", "test1") or die(mysql_error());
mysql_select_db("property") or die(mysql_error());

$type = $_POST['type'];
$state = $_POST['state'];
$city = $_POST['city'];
$zip = $_POST['zip'];
$pricemin = $_POST['pricemin'];
$pricemax = $_POST['pricemax'];
$squarefeetmin = $_POST['squarefeetmin'];
$squarefeetmax = $_POST['squarefeetmax'];

if(!isset($sl) || !isset($state))
{
        echo "Please fill in all of the fields required";
} else {


        $result = mysql_query("SELECT * FROM properties WHERE type='$type' and state='$state' ORDER BY price");

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

(I'm missing a ton of logic here)




                        echo "<B>Name</B>: ".$row['name'];
                        echo "<br><B>Type of Property</B>: ".$row['type']."<br />";
                        echo "<B>State</B>: ".$row['state']."<br />";
                        echo "<B>Price</B>: ".$row['price']."<br />";
                        echo "<B>Square feet</B>: ".$row['squarefeet']."<br /><br />";

        }
        }
?>

</body>
</html>
[/code]
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.