ASP 随机显示10条新闻
SETRs=Server.CreateObject("ADODB.Recordset")sql="select*fromSMT_ypwhereSMT_vip=2order...
SET Rs = Server.CreateObject("ADODB.Recordset")
sql = "select * from SMT_yp where SMT_vip=2 order by rnd(smt_id)"
Rs.Open sql,conn,1,3
随机显示10条 展开
sql = "select * from SMT_yp where SMT_vip=2 order by rnd(smt_id)"
Rs.Open sql,conn,1,3
随机显示10条 展开
6个回答
展开全部
<%
SET Rs = Server.CreateObject("ADODB.Recordset")
sql = "select top 10 * from SMT_yp where SMT_vip=2 "
Rs.Open sql,conn,1,3
do while not rs.eof
rs("字段名")
response.Write("<br>")
rs.movenext
loop
rs.close
set rs=nothing
%>
SET Rs = Server.CreateObject("ADODB.Recordset")
sql = "select top 10 * from SMT_yp where SMT_vip=2 "
Rs.Open sql,conn,1,3
do while not rs.eof
rs("字段名")
response.Write("<br>")
rs.movenext
loop
rs.close
set rs=nothing
%>
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
