<table width="96%" border="0" align="center" cellpadding="0" cellspacing="0">
<%
sql = "select * from [user] where id in (select Max(id) from [user] group by province) order by id desc"
set nRs=conn.execute(sql)
for i=1 to 12
if not nRs.eof then
%>
<tr>
<td align="left" style="line-height:17px"><a href="#">[<%=nRs("province")%>]</a>
<%
sql2 = " select * from [user] where 1=1 "
sql2 = sql2 & " and province='"&nRs("province")&"' "
sql2 = sql2 & " order by id desc "
set oRs=conn.execute(sql2)
for j=1 to 4
if not oRs.eof then
%>
<span style=" padding-left:1px;"><%=oRs("username")%></span>
<%
oRs.movenext
end if
next
oRs.close
%>
</span></td>
</tr>
<%
nRs.movenext
end if
next
nRs.close
%>
</table>
