<!--#include file="db_conn.asp"-->
<%
sqlselect = "select distinct province from [citysee$]"
province = request("province")
if province<>"" then sqlselect = "select city from [citysee$] where province='"&province&"'"
set rs = conn.execute(sqlselect)
%>
<br>
<p align="center" style="font-size:15px;color:blue;"><b>EMS送货城市列表</b></p>
<table align="center" border="0" cellPadding="0" cellSpacing="0" width="430" style="font-size:13px;">
<tr>
<%
do while not rs.eof
if province<>"" then
response.write "<td height=""23"">" & rs("city") & "</td>"
else
response.write "<td height=""23""><a href=showcity.asp?province=" & rs("province") & ">" & rs("province") & "</a></td>"
end if
i = i + 1
if i = 5 then
i = 0
k = k + 1
if k mod 2 = 1 then
response.write "</tr><tr bgcolor=""#e2f0f9"">"
else
response.write "</tr><tr >"
end if
end if
rs.movenext
loop
%>
</tr>
</table>
<%
if province<>"" then
response.write "<p align=""center"" style=""font-size:14px;""><a href=""javascript:history.back();""><b>返回上级</b></a></p>"
else
response.write "<p align=""center"" style=""font-size:14px;""><a href=""javascript:window.close();""><b>关闭窗口</b></a></p>"
end if
%>