[SOLVED] price range

[anthony-needs-you]

Hi everyone, i am trying to create a search fuction with a price range.

 

The html for the price range is:

 

 <select name="pricerange" class="field">
          <option selected="selected">any price</option>
          <option value="0:100">£0 - £100</option>
          <option value="101:300">£101 - £300</option>
          <option value="301:500">£301 - £500</option>
        </select>

 

and the php is

 

list($min,$max) = explode(':',$_POST['pricerange'],2);

$result = mysql_query("SELECT departureDate, expireDate, airport, destination, resort, hotel, duration, board, price, description, customerRef, mystiqueRef, stars FROM holiday WHERE destination LIKE '%$where%' AND duration LIKE '%$stay%' AND price BETWEEN '%$min' AND '%$max'");

 

The price range is not working?

[rhodesa]

remove the % before $min and $max

[anthony-needs-you]

you star, thanks