<% Dim rs1 Dim rs1_numRows Set rs1 = Server.CreateObject("ADODB.Recordset") rs1.ActiveConnection =

 我来答

1个回答

#热议# 上班途中天气原因受伤算工伤吗？

我希宝0X
2010-11-10 · TA获得超过768个赞

知道答主

回答量：562

采纳率：0%

帮助的人：194万

我也去答题访问个人页

关注

展开全部

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>

<%
Dim rs1
Dim rs1_cmd
Dim rs1_numRows

Set rs1_cmd = Server.CreateObject ("ADODB.Command")
rs1_cmd.ActiveConnection = MM_ggx_STRING
rs1_cmd.CommandText = "SELECT * FROM info_total"
rs1_cmd.Prepared = true

Set rs1 = rs1_cmd.Execute
rs1_numRows = 0
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index

Repeat1__numRows = 10
Repeat1__index = 0
rs1_numRows = rs1_numRows + Repeat1__numRows
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "">
<html xmlns="">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>repeat</title>
<style type="text/css">

</style>
</head>

<body>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<%
i=0
While ((Repeat1__numRows <> 0) AND (NOT rs1.EOF))
%>
<td> <table width="146" height="166" border="0">
<tr>
<td width="132" height="115"><img src="manage/<%=(rs1.Fields.Item("pic_path").Value)%>" alt="" width="140" height="130" /></td>
</tr>
<tr>
<td height="22"><span class="STYLE2"><%=(rs1.Fields.Item("info_name").Value)%></span></td>
</tr>
<tr>
<td><span class="STYLE2"><%=(rs1.Fields.Item("info_content").Value)%></span></td>
</tr>
</table></td>
<%
i=i+1
if i mod 5 = 0 then response.Write "</tr><tr>"
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
rs1.MoveNext()
Wend
%>
</tr>
</table>
</body>
</html>
<%
rs1.Close()
Set rs1 = Nothing
%>

可以通过修改if i mod 5后面的数字控制每行显示个数！
请参考

本回答由提问者推荐

已赞过 已踩过<

评论收起

推荐律师服务：若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询

<% Dim rs1 Dim rs1_numRows Set rs1 = Server.CreateObject("ADODB.Recordset") rs1.ActiveConnection =

其他类似问题

为你推荐：