21,886
社区成员
发帖
与我相关
我的任务
分享
$kind=$_GET['kind']+0;
$querykind=mysql_query("select * from kind where kind_id='$kind' or kind_fid='$kind' order by kind_id asc");
while($resultkind=mysql_fetch_array($querykind))
{
$kindarr[]="kind_id='".$resultkind['kind_id']."' ";//把当前选择分类的ID和其子分类ID都放进数组
}
//中间省略部分
if($kind==0)//没有选择分类就显示全部
{
$sql="select * from passage LEFT JOIN kind ON passage.kind_id = kind.kind_id limit $startrecord,$offset";
}
else
{
$sql="select * from passage LEFT JOIN kind ON passage.kind_id = kind.kind_id where ".implode(' or ',$kindarr)."limit $startrecord,$offset";
}