Select All and Numbers range SQL

Techissue2008

I have a search engine which has a drop down menu field for searching criterion.

<select name="price">
<option value="0">Select All</option>
<option value="2">Below 200</option>
<option value="10">201 - 1000</option>
<option value="50">1001 or Above</option>	
</select>

$price = trim($_POST['price']);

$query = "SELECT productid, price FROM product where price = $price";

Product Table
productid price
1 100
2 400
3 8000
4 900

My questions are:
1) If user selects all in option with '0' value, there is no output. But, I want to show all data in product table.

2) If user selects 201 - 1000 which has '10' as value, there is no output. But, I want to select a range of price inbetween 201-1000 which should show 3 rows of data in above example.

How can I do these 2 tasks in SQL?

Thanks for help.

Techissue2008

anyone could help?

cahva

Well this should get you on the right track:

$price = trim($_POST['price']);

switch ($price) {
	case 0:
	default:
		$where = '';
		break;

case 2:
	$where = 'WHERE price <= 200';
	break;

case 10:
	$where = 'WHERE price BETWEEN 201 AND 1000';
	break;

case 50:
	$where = 'WHERE price >= 1001';
	break;
}

$query = "SELECT productid, price FROM product {$where}";

Techissue2008

If I have another drop down menu, a text box and a radio group for where conditions, how can i do it with the case?

<select name="model">
<option value="0">Select All</option>
<option value="1">Below 1000</option>
<option value="2">1001 - 2000</option>
<option value="50">2001 or Above</option>	
</select>

<input type="text" name="productname">

<input type="radio" name="type" value="1" checked>Star series
<input type="radio" name="type" value="2">Moon series

Can I set $query = "SELECT productid, price FROM product {$where + $where1 + $where2 + $where3 }";

Thanks for advice