<table width="500" border="0" cel
lsp
acing="0" cellpadding="0">
<tr>
<%
set rs1=server.createobject("adodb.recordset")
sql1="select * from Classtable where parentid=0 order by orderdate desc"
rs1.open sql1,conn,1,1
if rs1.eof or rs1.bof then
response.write"<td align=""center"">还没分类!</td>"
else
n=0
do while not rs1.eof
n=n+1
id1=rs1("classid")
name1=rs1("classname")
%>
<td bgcolor="#CCCCCC"><a href="products.asp?id=<%=id1%>&hid=<%=id1%>" class="left1"> <%=name1%></a></td>
<%
if n mod 2 =0 then response.Write("</tr><tr>")
rs1.movenext
loop
end if
rs1.close
set rs1=nothing
%>
</tr>
</table>

if n mod 2 =0 then response.Write("</tr><tr>") 这里可以改一排显示几个

sql1="select top 4 * from Classtable where parentid=0 order by orderdate desc"
“top 4 * ” 查询数据库前4条记录的所有字段