if(!empty($typeid))7 A u! }& \. M1 ?; E修改成:! ^: t/ ?: v8 e7 K6 d6 G/ L. a4 @3 w
{
$addsql = ” where typeid=’$typeid’ “;
}
$dsql->SetQuery(“Select tid From `#@__taglist` where arcrank<=-1″); $dsql->Execute();- X5 p+ H6 K, k# p8 s: [$ D" Q这样就不会显示的未审核稿件的标签.
$ids = ”;
while($row = $dsql->GetArray())4 K& l. ?% I; r1 i' G# t$ F( s
{
$tid = $row['tid'];' J/ m I& F, c {) s/ R$ C
$cquery = “Select count(*) as dd From `#@__taglist` where tid = $tid and arcrank<=-1″;! Z9 Q, p2 B7 q! P
$crow = $dsql->GetOne($cquery);
if(!$crow['dd'])
{
$ids .= ( $ids==” ? $row['tid'] : ‘,’.$row['tid'] );, J2 x9 W# v! i7 x5 ^5 e
}
}( ^* s/ J6 g/ M
if($ids != ”)
{
$addsql = ” where id not in($ids) “;
}. L4 S; b" I9 b3 T
if(!empty($typeid))$ O* D' |- |, y
{0 }0 G+ M4 L: c% c
if($addsql)% R, I6 S: @7 q- V+ c( _+ Q- Z2 W
{2 \4 z/ Q" [3 Z1 B6 a
$addsql .= ” and typeid=’$typeid’ “;
}else{
$addsql = ” where typeid=’$typeid’ “;: z0 o: `# [" \" }# w2 R: ~
}0 k" ~. `$ A a; V+ a+ K* T' y
}! h3 p; _% e- a, m- L5 T! \
欢迎光临 航空论坛_航空翻译_民航英语翻译_飞行翻译 (http://bbs.aero.cn/) | Powered by Discuz! X2 |