//Start

$hack_subject_len=34; //

$hack_subject_num=10; //

//最新贴

$query = $db->query("SELECTdateline,tid,subject,author,views,replies FROM {$tablepre}threads ORDERBY dateline DESC LIMIT 0, $hack_subject_num");

while($thread = $db->fetch_array($query)) {

         $thread[subject0]=$thread[subject];

        $thread['subject'] = cutstr($thread['subject'], $hack_subject_len);

        $hack_newthreads_threadlist[] = $thread;

}





$threadview = $threadreply = array();



//最新回复

$query = $db->query("SELECT replies, tid,subject,author,views,lastposter FROM {$tablepre}threads where replies!=0 ORDER BY lastpost DESC LIMIT 0, $hack_subject_num");

        while($thread = $db->fetch_array($query)) {

                 $thread[subject0]=$thread[subject];

                $thread[subject] = cutstr($thread[subject], $hack_subject_len);

                $threadreply[] = $thread;

        }

//End

原帖由 中原之星 于 2006-12-30 21:47 发表
可以在SQL查询里加一个条件