if(!empty($typeid)) S |7 g6 }1 ^. K; i8 O: @: x' d修改成:9 J! _- z$ t4 s( n. S4 R4 R( V7 o
{9 F9 C x+ R# h1 V u* c
$addsql = ” where typeid=’$typeid’ “;
}
$dsql->SetQuery(“Select tid From `#@__taglist` where arcrank<=-1″); $dsql->Execute();% Z$ c2 k7 o& [9 k, T这样就不会显示的未审核稿件的标签.
$ids = ”;0 Z5 Z5 u2 {4 `0 u# Q" Y+ L V' F
while($row = $dsql->GetArray())
{! H7 j- }0 d" `* a) I
$tid = $row['tid'];1 Y4 ]5 {6 ~+ j" [$ i
$cquery = “Select count(*) as dd From `#@__taglist` where tid = $tid and arcrank<=-1″;4 o" Q9 K* t7 Q0 C) u+ b( q
$crow = $dsql->GetOne($cquery);
if(!$crow['dd'])
{3 D9 A, j/ M3 r5 @. V a
$ids .= ( $ids==” ? $row['tid'] : ‘,’.$row['tid'] );: |! L/ L, A, o
}' d! ]+ A& [) ?# J5 c6 @
}9 B) P; u- _/ Y, N/ P
if($ids != ”)1 ?/ O' S/ y- I R$ `, ]
{
$addsql = ” where id not in($ids) “;
}
if(!empty($typeid))4 @& r5 e8 ]5 `, ]0 ]! O! V7 e) X3 E
{5 B9 k' c! L+ ~0 z& p1 m
if($addsql)8 w O! ]& f6 P# `, t! ^4 K
{
$addsql .= ” and typeid=’$typeid’ “;5 h% X% ]: T! V6 @6 m) j" s
}else{
$addsql = ” where typeid=’$typeid’ “;
}
}3 E( `/ ?% y+ e; F5 K+ X
欢迎光临 航空论坛_航空翻译_民航英语翻译_飞行翻译 (http://bbs.aero.cn/) | Powered by Discuz! X2 |