UC知道asp 如何显示3行一列
来源：百度知道 编辑：UC知道 时间：2024/09/22 09:58:54
请高手帮忙，怎么能让它显示3行一列，7是列数还是什么？我是菜鸟，对程序不懂。先谢谢啦~~
<%
SqlSort = "select top 7 * from zf11_guide where B_id=6 order by S_Order"
Set RsSort = Conn.Execute(SqlSort )
if RsSort.eof and RsSort.bof then
Response.write("<div align=center >还没有任何栏目......</div>")
response.end
else
%>
<tr>
<% do while not RsSort.eof %>
<td align="center">[<a target="_blank" href="guide_list.asp?classID=<%=RsSort("ID")%>"><%=RsSort("Names")%></a>]</td>
<%
RsSort.movenext
loop
end if
RsSort.close
set RsSort=nothing
%>
你这答案没解决问题呀，我的代码都发上来啦，你那个我不知道怎么改呀，谁能有好的答案？！！
<%
SqlSort = "select top 7 * from zf11_guide where B_id=6 order by S_Order"
Set RsSort = Conn.Execute(SqlSort )
if RsSort.eof and RsSort.bof then
Response.write("<div align=center >还没有任何栏目......</div>")
response.end
else
%>
<tr>
<% do while not RsSort.eof %>
<td align="center">[<a target="_blank" href="guide_list.asp?classID=<%=RsSort("ID")%>"><%=RsSort("Names")%></a>]</td>
<%
RsSort.movenext
loop
end if
RsSort.close
set RsSort=nothing
%>
你这答案没解决问题呀，我的代码都发上来啦，你那个我不知道怎么改呀，谁能有好的答案？！！
给你个显示N行N列的代码
<table border="0" cellpadding="0" cellspacing="2">
<%
response.write "<tr>"
set rs=server.createobject("adodb.recordset")
sql="select * from shop_snsn where nclassid='|121|'"
rs.open sql,conn,1,1
tempnum2=1
do while not rs.eof
shoppic=trim(rs("shoppic"))
cjname=trim(rs("cjname"))
%>
<td width="122" height="110" align="center" valign="top" bgcolor="#FFFFFF">
<table width="120" height="90" border="0" cellpadding="0" cellspacing="1" bgcolor="#66FFFF">
<tr>
<td><a href= ../list.asp?id=<%=rs("shopid")%> target=_blank><img src="<%=weburl%><%=shoppic%>" alt=<%=shopname%> width=120 height=90 border=0></a