if(!empty($typeid)){$addsql = " where typeid='$typeid' ";}修改为
$dsql->SetQuery("Select tid From `dede_taglist` where arcrank<=-1"); $dsql->Execute(); $ids = ''; while($row = $dsql->GetArray()) { $tid = $row['tid']; $cquery = "Select count(*) as dd From `dede_taglist` where tid = $tid and arcrank<=-1"; $crow = $dsql->GetOne($cquery); if(!$crow['dd']) { $ids .= ( $ids=='' ? $row['tid'] : ','.$row['tid'] ); } } if($ids != '') { $addsql= " where id not in($ids) "; } if(!empty($typeid)) { if($addsql) { $addsql= " and typeid='$typeid' "; }else{ $addsql= " where typeid='$typeid'" ; } }方法二 找到
$row['keyword'] = $row['tag'];在其前边加入:
$rankrowss = $dsql -> GetOne("SELECT count(tid) as rankcount FROM `js_taglist` WHERE tid = $row[id] and arcrank >= 0");if($rankrowss[rankcount] == 0) continue;通过以上两种方法就可以实现不显示未审核文档的tag了 。
新闻热点
疑难解答