query("SELECT SQL_CALC_FOUND_ROWS A.* FROM {$pre}article A LEFT JOIN {$pre}sort B ON A.fid=B.fid WHERE A.yz=1 AND B.fup='$fid' ORDER BY list DESC LIMIT $min,$rows"); $RS=$db->get_one("SELECT FOUND_ROWS()"); $NUM=$RS['FOUND_ROWS()']; $showpage=getpage('','',"list.php?fid=$fid",$rows,$NUM); while($rs = $db->fetch_array($query)){ $key++; if($key==1&&$page<2){ $r=$db->get_one("SELECT * FROM {$pre}reply WHERE aid='$rs[aid]' AND topic=1"); $rs[content]=preg_replace('/<([^<]*)>/is',"",$r[content]); $rs[content]=preg_replace('/ | | /is',"",$rs[content]); } $rs[posttime]=date("Y-m-d H:i",$rs[posttime]); $listdb[]=$rs; } ?>
$fidDB[name] |
{$rs[content]} 共有{$rs[hits]}人关注 评论{$rs[comments]}条 [阅读全文]
$showpage
|