<%set rs=server.CreateObject("adodb.recordset")
rs.open "select Top 10 * from shjia where flag=2 order by adddate desc",conn,1,1
%>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<%do while not rs.eof%>
<tr> 
<td height="24" class="table-you"  STYLE='PADDING-LEFT: 18px'><img src="images/bar2.gif" width="10" height="10">
<%response.write "<a href=user/index.asp?id="&rs("shjiaid")&" title=加盟時(shí)間："&rs("adddate")&"次 >"
				if len(trim(rs("name")))>12 then
				response.write left(trim(rs("name")),10)&".."
				else
				response.write trim(rs("name"))
				end if
				response.write "</a>"
				%>
</td>
</tr>
<%rs.movenext
	loop
	rs.close
	set rs=nothing%>
</table>