这个要用两个sql语句,要两个循环写
比如这个
sql="SELECT top 6 ID,Info_Title,Info_InputTime FROM qiugou ORDER BY Info_InputTime desc"
set rs=conn.execute(sql)
do while not rs.eof
response.write""
rs.movenext
loop
这是循环了你选择的开始前六条数据
你要接着循环出下一个六条数据,而且与前面数据是连接的,注意红色代码
sql="SELECT top 6 ID,Info_Title,Info_InputTime FROM qiugou WHERE ID not in(SELECT top 6 ID FROM qiugou ORDER BY Info_InputTime desc) ORDER BY Info_InputTime desc"
set rs=conn.execute(sql)
do while not rs.eof
ghostzp兄,我要从数据库调记录 啊。我怎么调啊。
<div id="OZLV2">
<%
FlagOZLV=12
Set RsOZLV=Conn.Execute("Select * From XLB where TJFLAG='1' order by [DateTime] Desc")
If not RsOZLV.eof then
%>
<table width="240" border="0" cellpadding="0" cellspacing="0">
<%
Do while Not RsOZLV.Eof And FlagOZLV>0
%>
<tr>
<td width="13" height="22" background="images/wz-bg1.gif"><img src="images/tu-1.gif" width="9" height="9"></td>
<td valign="bottom" background="images/wz-bg1.gif"><a href="OZLVDetails.asp?id=<%= RsOZLV("Id") %>" target="_blank"><%= CutString(RsOZLV("Title"),16,16,"l") %><%= flagozlv %></a></td>
</tr>
<% If FlagOZLV=6 Then P "</td>"%>
<%
RsOZLV.movenext
FlagOZLV=FlagOZLV-1
If RsOZLV.Eof then Exit do
Loop
%>
</table>
<%
Else
P "建设中..."
End if
RsOZLV.Close
Set RsOZLV=Nothing
%>
</div>
没想明白。数据库access。