php多条件外加查询

php多条件叠加查询

header("Content-Type:text/html;charset=utf-8");
include("../manage/include/function.php");
	$brand=substr($_POST["brand"],0,strlen($_POST["brand"])-1); 
	$color=substr($_POST["color"],0,strlen($_POST["color"])-1); 
	$caizhi=$_POST["caizhi"];
	$style=$_POST["style"];
	$kucun=$_POST["kucun"];
	echo($brand."
");
	echo($color."
");
	echo($caizhi."
");
	echo($style."
");
	echo($kucun);
	
	$q="select * from pros_pro where (1=1)";
	if($brand!=null){
		$q=$q+"and psp_brand in(".$brand.")";
	}
	if($color!=null){
		$q=$q+"and psp_color in(".$color.")";
	}
	if($caizhi!=null){
		$q=$q+"and psp_caizhi='".$caizhi."'";
	}
	if($style!=null){
		$q=$q+"and psp_style='".$style."'";
	}
	if($kucun!=null){
		$q=$q+"order by psp_stock desc";
	}else
	{
		$q=$q+"order by psp_id desc";
	}
	

	$rows=query($q);
	if($row=mysql_fetch_array($rows))
	{
		do{
?>
			

		}
	else
	{?>
		
没有符合条件的信息，请重新定义搜索条件!

		}
	?>