$query = DB::query(“SELECT DISTINCT t.*$sqlfield
FROM `”.DB::table(‘forum_thread’).”` t
$sqlfrom WHERE {$maxwhere}t.readperm=’0′
$sql
AND t.displayorder>=’0′
ORDER BY t.$orderby DESC
LIMIT $startrow,$items;”
);
#### 第三步:添加随机生成代码
在上述代码段的前面插入以下代码:
if($startrow==1000){
$yunhuifus = DB::query(“SELECT DISTINCT t.*$sqlfield
FROM `”.DB::table(‘forum_thread’).”` t
$sqlfrom WHERE {$maxwhere}t.readperm=’0′
$sql
AND t.displayorder>=’0′
ORDER BY t.$orderby DESC;”
);
$sqlNum = mysql_num_rows($yunhuifus);
$startrow = mt_rand(0, $sqlNum-$items);
}