# Help with min max prices ranges

**URL:** <https://forum.kirupa.com/t/help-with-min-max-prices-ranges/238310>\
**Category:** programming\
**Created:** [September 9, 2007, 9:04pm UTC](https://forum.kirupa.com/t/help-with-min-max-prices-ranges/238310 "2007-09-09T21:04:43Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![pp4sale](https://avatars.discourse-cdn.com/v4/letter/p/ee7513/32.png) [@pp4sale](https://forum.kirupa.com/u/pp4sale)\
**Post date:** [September 9, 2007, 9:04pm UTC](https://forum.kirupa.com/t/help-with-min-max-prices-ranges/238310/1 "2007-09-09T21:04:43Z")

</div>

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!