20,359
社区成员
发帖
与我相关
我的任务
分享
$max = "SELECT count(*) FROM TABLE_NAME";
//随机数池
$rand_pool = [];
while(count($rand) < 10){
$rand = mt_rand(1, $max);
if(!in_array($rand, $rand_pool)){
$rand_pool[] = $rand;
}
}
//要预先处理下$rand_pool
$sql = "SELECT * FROM TABLE_NAME WHERE `id` in {$rand_pool}";