１、
| mysql: select * from tablename order by rand() limit 1 |
//把limit后面的数值改为您想随机抽取的条数，我这里只取一条。
２、
$query= "SELECT count(*) as count FROM recommends";
....
$max_num = $row['count'];//取记录总数
srand((double)microtime()*1000000);//随机数种子
$se_pos = rand(0, $max_num);//随机数范围
$length = 6;//记录条数
if (($max_num - $se_pos) <= $length)
$se_pos = $max_num - $se_pos; //记录数不足6条的情况
$query = "SELECT * FROM recommendsn limit ".$se_pos.",".$length;
|