price range

[Anon]

Hi. I am trying to write a script that will be able to search ranges of price values in my database... What I have looks like this.

(html)

<select name="price" size="1">
<option value></option>
<option value="&lt; 1000">$0 - $1000 </option>
<option value="1000">$1000 - $1500 </option>
<option vaule="1001">$1500 - $2000 </option>
<option value="2000">$2000 - $2500 </option>
<option value="2001">$2500 - $3000 </option>
<option value="3000">$3000 - $3500 </option>
<option value="3001">$3500 - $4000 </option>
<option value="&gt; 4000">$4000 and up </option>
</select>

(php)

$result1 = mysql_query("SELECT * FROM trips WHERE region like '$region' AND price like '$price'",$db);

Will this work?

If not, can anyone tell me how I can make it work?

[Anon]

why not allow users to enter their own low and high prices? or give 2 selects...

then

$result1 = mysql_query("SELECT * FROM trips WHERE region like '$region' AND price>='$lowprice' AND price <='$highprice'",$db);

[Anon]

Ah yes. Thank you. Another question. How would I write the echo statement depending on which variable is currently selected...

result1, result2, and result3...

if($region=all){
$result1 = mysql_query("SELECT FROM trips WHERE cost>='$price1' AND cost<='$price2'",$db);
}
else if($countries=all){
$result2 = mysql_query("SELECT FROM trips WHERE region LIKE '$region' AND cost>='$price1' AND cost<='$price2'",$db);
}
else
{
$result3 = mysql_query("SELECT * FROM trips WHERE region LIKE '$region' AND country LIKE '$countries' AND cost>='$price1' AND cost<='$price2'",$db);
}