PHP随机从数据库读取N条数据

去掉foreach

$sql="select * from phome_ecms_wma order by rand() limit 30"

就行了

n=150

rs.open "select * from tmmm where id not in (select top " &n &" id from tmmm order

by id asc)",con,1,1