if(!empty($typeid))& W# N! v2 K: {5 v8 x7 Z( c修改成:
{# ~* E; b" R" `3 D) `
$addsql = ” where typeid=’$typeid’ “;5 A6 n+ f4 L9 K
}3 Z0 z5 d3 P: y( I( ?) J
$dsql->SetQuery(“Select tid From `#@__taglist` where arcrank<=-1″); $dsql->Execute();# L6 e$ X% }' E+ a% z, r4 T @这样就不会显示的未审核稿件的标签.
$ids = ”;
while($row = $dsql->GetArray())
{
$tid = $row['tid'];" ^, O# y7 y( W8 l& W9 G6 H1 `
$cquery = “Select count(*) as dd From `#@__taglist` where tid = $tid and arcrank<=-1″;
$crow = $dsql->GetOne($cquery);4 l9 X3 X# G8 A: i# h1 A9 h+ W
if(!$crow['dd'])
{
$ids .= ( $ids==” ? $row['tid'] : ‘,’.$row['tid'] );
}2 K7 D8 i! W; I1 L
}) |5 S- ~% O$ g H8 i' J
if($ids != ”); ~: A. [$ R" Q! M1 p
{ R' T% Z: N! C& i: H
$addsql = ” where id not in($ids) “;
}5 r0 F1 f+ T3 k* z/ q
if(!empty($typeid))
{" Y! J \2 T* G9 q1 @% A
if($addsql): n6 p! Q! L& O
{
$addsql .= ” and typeid=’$typeid’ “;
}else{
$addsql = ” where typeid=’$typeid’ “;3 a/ R9 g, P- Y$ m# f
}
}) U7 T3 u& x4 m
| 欢迎光临 航空论坛_航空翻译_民航英语翻译_飞行翻译 (http://bbs.aero.cn/) | Powered by Discuz! X2 |