怎么实现搜索只搜指定多栏目下的文章?
方法1:
//统计列表里的记录
- $cquery = "Select * From `archives` arc where arc.typeid not in (1,2,3...) and {$this->AddSql}";
//搜索
- $query = "Select arc.*,act.typedir,act.typename,act.isdefault,act.defaultname,act.namerule,
- act.namerule2,act.ispart,act.moresite,act.siteurl,act.sitepath
- from `archives` arc left join `arctype` act on arc.typeid=act.id
- where act.id not in (4,5,,6....) and {$this->AddSql} $ordersql limit $limitstart,$row";
把sql语句换成这两句,括号里面的是不搜索栏目的id
方法2:
- <input type="hidden" name="typeid" value="特定栏目id">
把它放在搜索form里面即可