ขอสอบถามวิธี search ช่วงเงินหน่อยคับว่าจะเสิทได้อย่างไรบ้างคับ

WHERE Total BETWEEN '500000' AND '800000'

$Act=$_GET['price'];
	switch($Act){
		case 'Between'	:	$Price=$_POST['Price'];
								if($Price == 'All'){
									$sql="SELECT * FROM listofcar WHERE price"; 
								}else if($Price <= 400000){
									$sql="SELECT * FROM car WHERE price BETWEEN '0' AND '399999'";
								}else if($Price <= 600000){
									$sql="SELECT * FROM car WHERE price BETWEEN '400001' AND '600000'";	
								}else if($Price <= 800000){
									$sql="SELECT * FROM car WHERE price BETWEEN '600001' AND '800000'";
								}else if($Price <= 1000000){
									$sql="SELECT * FROM car WHERE price BETWEEN '800001' AND '1000000'";	
								}else if($Price <= 1500000){
									$sql="SELECT * FROM car WHERE price BETWEEN '1000001' AND '1500000'";	
								}else if($Price <= 2000000){
									$sql="SELECT * FROM car WHERE price BETWEEN '1500001' AND '2000000'";
								}else if($Price > 2000000){
									$sql="SELECT * FROM car WHERE price BETWEEN '2000000' AND '100000000'";
								}
			
	}

$strSQL = "SELECT * FROM listofcar WHERE (seating LIKE '%".$_GET["seating"]."%' and engine LIKE '%".$_GET["engine"]."%'
					and doors LIKE '%".$_GET["doors"]."%' and gear LIKE '%".$_GET["gear"]."%' and fuel LIKE '%".$_GET["fuel"]."%'
					)";