[doveroh]

Hello,

I have a few different items that visitors fill out to search our listings...

the first one is just two check boxes where they fill in the min price and the max price they are willing to pay, (there is the min price and max price for each items also in data base), then they can check any one or more of the 5 check boxes that they are looking for in the listing... I was wondering if anyone had any idea how the SQL statement would be or how to search for this in the database? If you need more information, please let me know, and I will send you the link... This is the form:
http://www.rentleader.com/search.php?area=ne&carea=1

Thanks for any help anyone could provide.

Jes

[FiRe]

PHP Code:

$minimum = $_POST['textbox1'];

$maximum = $_POST['textbox2'];

mysql_query("SELECT result FROM table WHERE min >= $minimum AND max <= $maximum");