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(1){ $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]); $rs[picurl]=tempdir("$rs[picurl]"); $rs[picurl]=filtrate($rs[picurl]); $listdb[]=$rs; } ?>

$fidDB[name]

$rs[title]
$rs[content]

分类:{$rs[fname]} {$rs[posttime]}

$rs[title]
$rs[content]

分类:{$rs[fname]} {$rs[posttime]}

$showpage