if(!empty($typeid))修改成:
{8 i& F. r/ t" b3 l" T ~. u
$addsql = ” where typeid=’$typeid’ “;2 }' S( i& f1 h
}4 a" F/ k$ Q7 _; c% U2 _
$dsql->SetQuery(“Select tid From `#@__taglist` where arcrank<=-1″); $dsql->Execute();这样就不会显示的未审核稿件的标签.
$ids = ”;; X* x' K" R! z# b, i z2 H+ P7 ]
while($row = $dsql->GetArray())
{
$tid = $row['tid'];5 i$ C$ D# C9 l. A# s
$cquery = “Select count(*) as dd From `#@__taglist` where tid = $tid and arcrank<=-1″;2 M, P3 J# L6 g4 W, ]
$crow = $dsql->GetOne($cquery);
if(!$crow['dd'])
{
$ids .= ( $ids==” ? $row['tid'] : ‘,’.$row['tid'] );2 D& L6 b; L! ]
}
}
if($ids != ”)
{
$addsql = ” where id not in($ids) “;1 k7 X% s! V7 B# v
}
if(!empty($typeid))
{
if($addsql)
{
$addsql .= ” and typeid=’$typeid’ “;8 @% t) q: A {$ a
}else{
$addsql = ” where typeid=’$typeid’ “;
}
}- B7 M6 d/ A. g+ Q
| 欢迎光临 航空论坛_航空翻译_民航英语翻译_飞行翻译 (http://bbs.aero.cn/) | Powered by Discuz! X2 |