PHP根据大分类查询所有子类文章包括自身

//根据大分类查询所有分类包括自身的文章$cid = $_GET['cid']; //获取分类IDif($cid != ''){$query1 = mysql_query("select * from ".$lan."_product_cate where cpid=$cid",$conn);//根据分类ID查询是否有子类if (mysql_num_rows($query1)>0){$catecid = array($cid);//加入本分类while($row1= mysql_fetch_array($query1)){$catecid[].=$row1["cid"]; //循环加入子分类}$catecid=implode(',',$catecid);//拆分分类ID$sql = "select * from ".$lan."_product where pcid in ($catecid) order by porder,pid"; //根据ID数组查询文字$num = RsNum($sql);//获取查询总数}else{$sql = "select * from ".$lan."_product where pcid = $cid order by porder,pid"; //根据分类ID搜索$num = RsNum($sql);//如果没有子类就查本身}}