if(!empty($typeid))4 P; M) c& B( Y3 y# D$ e4 L6 b修改成:% e: L/ N( n" ?2 t. `, d
{/ i) Z( d# m L) \3 I: r0 }
$addsql = ” where typeid=’$typeid’ “;6 W2 B# @$ }4 E, q/ p7 a( ^
}0 q( ^' {, r# o5 u# t, R/ d
$dsql->SetQuery(“Select tid From `#@__taglist` where arcrank<=-1″); $dsql->Execute();这样就不会显示的未审核稿件的标签.
$ids = ”;; W5 ?! L0 O }9 i" f y
while($row = $dsql->GetArray()); L5 x' _3 n. S1 L) h3 ^( m
{- ~- g: G$ T# ]9 f$ Q
$tid = $row['tid'];2 i. _# T7 s$ s: P( j4 R" T
$cquery = “Select count(*) as dd From `#@__taglist` where tid = $tid and arcrank<=-1″;; a8 C- s( o$ i( q: r
$crow = $dsql->GetOne($cquery);' R+ b( @$ W$ @, [- {( A1 i
if(!$crow['dd'])0 h; t) t3 {2 i1 g2 M
{4 v. W; P L9 M2 ?
$ids .= ( $ids==” ? $row['tid'] : ‘,’.$row['tid'] );
}) o2 ~4 S5 ~8 @# ~6 V% c6 z; K
}- f- Z; O0 p0 Q# c
if($ids != ”)% ^' _, ^9 y# Y1 M( f! r9 C
{
$addsql = ” where id not in($ids) “;
}, y- l+ @: \/ a: B; Z0 j% b
if(!empty($typeid))9 G2 }) x3 B( {- e% C
{
if($addsql)
{+ e+ Q5 H$ Q- n" C
$addsql .= ” and typeid=’$typeid’ “;
}else{4 y) H. B. |* i' l9 f$ c. h8 [* \
$addsql = ” where typeid=’$typeid’ “;! q$ S6 L5 [& b3 x6 P
}
}
欢迎光临 航空论坛_航空翻译_民航英语翻译_飞行翻译 (http://bbs.aero.cn/) | Powered by Discuz! X2 |