<!--#include file="conn.asp"-->
<%
set rs=cn.execute("select top 5 * from xinxibiao order by rnd(id)")
do while not rs.eof
response.write rs("title")&"<br>"
rs.movenext
loop
%>
每次刷新都是一样5条记录.
...全文
293打赏收藏
随机取记录,怎么取的都一样?
<% set rs=cn.execute("select top 5 * from xinxibiao order by rnd(id)") do while not rs.eof response.write rs("title")&"" rs.movenext loop %> 每次刷新都是一样5条记录.
<!--#include file="conn.asp"-->
<%
set rs=cn.execute("select top 5 * from xinxibiao order by rnd(1)")
do while not rs.eof
response.write rs("title")&"<br>"
rs.movenext
loop
%>