#32004/7/29 8:50:30
举例:
<table border="1" width="61%" bordercolorlight="#000000" cellspacing="0" cellpadding="0" bordercolordark="#FFFFFF">
<tr>
<td width="12%" >
<%set rs=conn.execute("select * from city where parentid="& parentid &" order by cityid")
if not rs.eof then
i=0%>
<table border="0" width="100%">
<%do while not rs.eof
'set obj=conn.execute("select count(*) from city where parentid="& rs("cityid") &" ")
if i=0 then response.write "<tr>"%>
<td width="12%" align="center" bgcolor="#E0F3FC" height="25"><a href="country.asp?parentid=<%=rs("cityid")%>&cid=<%=parentid%>"><%=rs("city")%></a> <a href="delete.asp?cityid=<%=rs("cityid")%>" onclick="return confirm('确定删除吗?');" ><font color=red>删除</font></a></td>
<%
i=i+1
col=5 '=====一排分col列
if i>0 and i mod col=0 then response.write "</tr><tr>"
rs.movenext
loop
%>
</table>
<%else
response.write "<br><br><br><center>暂无城市(地级市)<br><br><br></center>"
end if
conn.close
set conn=nothing
%>
</td>
</tr>
</table>