SELECT Condos.BathsTotal, Condos.Beds, Condos.City, Condos.ListPrice, Condos.StreetName
FROM Condos
WHERE Condos.Beds=varBeds AND Condos.BathsTotal=varBaths

<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$varBeds_belleResults = "-1";
if (isset($_GET['beds'])) {
  $varBeds_belleResults = $_GET['beds'];
}
$varBaths_belleResults = "-1";
if (isset($_GET['baths'])) {
  $varBaths_belleResults = $_GET['baths'];
}
mysql_select_db($database_connBelle, $connBelle);
$query_belleResults = sprintf("SELECT Condos.BathsTotal, Condos.Beds, Condos.City, Condos.ListPrice, Condos.StreetName FROM Condos WHERE Condos.Beds=%s AND Condos.BathsTotal=%s", GetSQLValueString($varBeds_belleResults, "int"),GetSQLValueString($varBaths_belleResults, "text"));
$belleResults = mysql_query($query_belleResults, $connBelle) or die(mysql_error());
$row_belleResults = mysql_fetch_assoc($belleResults);
$totalRows_belleResults = mysql_num_rows($belleResults);
?>

SELECT Condos.BathsTotal, Condos.Beds, Condos.City, Condos.ListPrice, Condos.StreetName, Condos.County
FROM Condos
WHERE Condos.ListPrice < varHp AND Condos.ListPrice > varLp AND Condos.City=varCity AND Condos.County=varCounty AND Condos.Beds=varBeds AND Condos.BathsTotal=varBaths

$query_belleResults = sprintf("SELECT Condos.BathsTotal, Condos.Beds, Condos.City, Condos.ListPrice, Condos.StreetName FROM Condos WHERE 1=1");
IF $varBeds_belleResults > 0 THEN $query_belleResults = $query_belleResults + " AND Condos.Beds=%s", GetSQLValueString($varBeds_belleResults, "int"));
IF $varBaths_belleResults > 0 THEN $query_belleResults = $query_belleResults + " AND Condos.BathsTotal=%s",GetSQLValueString($varBaths_belleResults, "text"));

quote:

---

Originally posted by Jake Belk

Thanks for the quick response. I think I have simplified the search to much for this demo. The OR does work, but it doesn't retrieve all data if the field is left empty (value"").

Brett, I'm pretty new at this and I have never created a Stored Procedure. I guess I want to know how to create a query that gives the client flexibility to select or not to select a field. But when left empty, any value would be shown. I have given Price a predetermined range ($50,000 - $400,000) Is there a default value that will deliver everything when no value is selected?

This was my original sql code:

SELECT Condos.BathsTotal, Condos.Beds, Condos.City, Condos.ListPrice, Condos.StreetName, Condos.County
FROM Condos
WHERE Condos.ListPrice < varHp AND Condos.ListPrice > varLp AND Condos.City=varCity AND Condos.County=varCounty AND Condos.Beds=varBeds AND Condos.BathsTotal=varBaths

---

SELECT Condos.BathsTotal, Condos.Beds, Condos.City, Condos.ListPrice, Condos.StreetName, Condos.County
FROM Condos
WHERE (Condos.City=varCity OR varCity='Any') AND (Condos.Beds=varBeds OR varBeds='Any')  AND (Condos.BathsTotal=varBaths OR varBaths='Any') AND (Condos.County=varCounty OR varCounty='Any')
ORDER BY Condos.ListPrice DESC