Help with min max prices ranges

programming
1

Hi

I’m trying to to create a drop down search field that will search ranges of prices. eg select a min price and a max price. Below is my php but I can’t get it to work! Any help please? This page feeds into another page so that it just has:
<td>Price:</td>
<td width=“66”>
<?=$MinPrice?>
in the actual form.

if(isset($_POST[‘s1’]) || isset($_POST[‘s1_x’]))
{
if(!empty($_POST[‘cat’]))
{
$CatInfo = explode("|", $_POST[‘cat’]);
$c = $CatInfo[‘0’];

if($CatInfo[‘1’] > ‘0’)
{
$s = $CatInfo[‘1’];
}
}

if(!empty($_POST[‘MinPrice’]))
{
$MinPrice = $_POST[‘MinPrice’];
}
if(!empty($_POST[‘MaxPrice’]))
{
$MaxPrice = $_POST[‘MaxPrice’];
}
$url = “search.php?c=$c&s=$s&search_country=$_POST[search_country]&search_state=$_POST[search_state]&search_PropertyType=$_POST[search_PropertyType]&MaxPrice=$MaxPrice&MinPrice=$MinPrice&rooms1=$rooms1&rooms2=$rooms2&btype=$btype”;
header(“location:$url”);
exit();
}

$MinPrice = “<select name=MinPrice>
<option value=“0”>None</option>
<option value=“100,000”>€100,000</option>
<option value=“200,000”>€200,000</option>
<option value=“300,000”>€300,000</option>
<option value=“400,000”>€400,000</option>
<option value=“500,000”>€500,000</option>
<option value=“600,000”>€600,000</option>
<option value=“700,000”>€700,000</option>
<option value=“800,000”>€800,000</option>
<option value=“900,000”>€900,000</option>
<option value=”">Minimum</option>
“;
$q1 = “SELECT * FROM re_listings WHERE Price BETWEEN minvalue AND maxvalue order by Price asc”;
$r1 = mysql_query($q1) or die(mysql_error());
if(mysql_num_rows($r1) > ‘0’)
{
while($a1 = mysql_fetch_array($r1))
{
$prices .= “<option value=”$a1[Price]”>€ $a1[Price]</option>
“;
}
}
$MinPrice .= $prices.”</select>
";

//create the max price menu
$MaxPrice = “<select name=MaxPrice>
<option value=”">Maximum</option>
<option value=“100,000”>€100,000</option>
<option value=“200,000”>€200,000</option>
<option value=“300,000”>€300,000</option>
<option value=“400,000”>€400,000</option>
<option value=“500,000”>€500,000</option>
<option value=“600,000”>€600,000</option>
<option value=“700,000”>€700,000</option>
<option value=“800,000”>€800,000</option>
<option value=">900,000">€900,000 +</option>
“;
$MaxPrice .= $prices.”</select>
";

?>

Thanks!