ivalea Posted March 9, 2006 Share Posted March 9, 2006 Hi!I am trying to build a search form (am still pretty new to PHP and MySQL so please bear with me) that searches by min and max price by dropdown - like on a real estate site. Right now it's written so that if there are any listings in the database then it takes those prices and puts them in the dropdown. Otherwise if there are no listings then the dropdown shows no options. My code is this:$MinPrice = "<select name=min>\n\t<option value=\"\">Minimum</option>\n\t";$q1 = "select distinct Price from re2_listings 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>\n\t"; }}$MinPrice .= $prices."</select>\n";//set the max price menu$MaxPrice = "<select name=max>\n\t<option value=\"\">Maximum</option>\n\t";$MaxPrice .= $prices."</select>\n";Then all I do is reference <?=$MinPrice?> and <?=$MaxPrice?> in the html form where the select should be.I need the dropdown to display price values in increments of $50,000 starting at $150,000 and ending at $1,000,000+.I tried inserting a select field in the form the way it normally would be and then setting id's to MinPrice and MaxPrice but that didn't work.Sorry to be soooo long winded but I've been at this for what seems forever and I so need help! :)Any thoughts at all as to how I can accomplish this would be sooo greatly appreciated! Thanks! - Irene Quote Link to comment https://forums.phpfreaks.com/topic/4510-search-by-min-and-max-price/ Share on other sites More sharing options...
redarrow Posted March 9, 2006 Share Posted March 9, 2006 An example of the way i done the select box thats all good luck.1 to 1099 poundIn drop down box[code]$a=$_POST['a']; // box1$b=$_POST['b'];// box2$c=$_POST['c'];//box3$d=$_POST['d'];//box4$price=('£'.$a.'.'.$b.$c);[/code][code]<td>Price</td><td><SELECT NAME="a"><OPTION VALUE="0">0</option><OPTION VALUE="1">£1</option><OPTION VALUE="2">£2</option><OPTION VALUE="3">£3</option><OPTION VALUE="4">£4</option><OPTION VALUE="5">£5</option><OPTION VALUE="6">£6</option><OPTION VALUE="7">£7</option><OPTION VALUE="8">£8</option><OPTION VALUE="9">£9</option><OPTION VALUE="10">£10</option><OPTION VALUE="20">£20</option><OPTION VALUE="30">£30</option><OPTION VALUE="40">£40</option><OPTION VALUE="50">£50</option><OPTION VALUE="60">£60</option><OPTION VALUE="70">£70</option><OPTION VALUE="80">£80</option><OPTION VALUE="90">£90</option><OPTION VALUE="100">£100</option><OPTION VALUE="200">£200</option><OPTION VALUE="300">£300</option><OPTION VALUE="400">£400</option><OPTION VALUE="500">£500</option><OPTION VALUE="600">£600</option><OPTION VALUE="700">£700</option><OPTION VALUE="800">£800</option><OPTION VALUE="900">£900</option><OPTION VALUE="1000">£1000</option></SELECT><SELECT NAME="b"><OPTION VALUE="0">0</option><OPTION VALUE="1">1</option><OPTION VALUE="2">2</option><OPTION VALUE="3">3</option><OPTION VALUE="4">4</option><OPTION VALUE="5">5</option><OPTION VALUE="6">6</option><OPTION VALUE="7">7</option><OPTION VALUE="8">8</option><OPTION VALUE="9">9</option><OPTION VALUE="10">10</option></SELECT><SELECT NAME="c"><OPTION VALUE="0">0</option><OPTION VALUE="1">1</option><OPTION VALUE="2">2</option><OPTION VALUE="3">3</option><OPTION VALUE="4">4</option><OPTION VALUE="5">5</option><OPTION VALUE="6">6</option><OPTION VALUE="7">7</option><OPTION VALUE="8">8</option><OPTION VALUE="9">9</option><OPTION VALUE="10">10</option></SELECT>[/code] Quote Link to comment https://forums.phpfreaks.com/topic/4510-search-by-min-and-max-price/#findComment-15703 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.