<%
set rs=server.createobject("adodb.recordset")
rs.open "select top 4 * from [flv]  order by hits desc",conn,1,1 
%>

					<div > <%

						i=1
do while not rs.eof
%>

</div>

				        
				   <div class="video">

					<ul>
					<li class="v_img"> <a href=photo_show.asp?photoid=<%=rs("photoID")%> target="_blank"><img name="picbg_r1_c1" src="<%=rs("PhotoUrl_Thumbsm")%>" width="120" height="95" border="0" alt=""></a></li>
					<li class="v_name"><a href=photo_show.asp?photoid=<%=rs("photoID")%> target="_blank"><%=left(rs("photoname"),5)%></a></li>
					<li class="v_user">²¥¿Í£º<%
set rsf=server.createobject("adodb.recordset")
rsf.open "select * from [user] where username='"&rs("editor")&"' order by userid desc",conn_user,1,1 
%><a href=user.asp?userid=<%=rsf("userid")%> target="_blank"><%=rs("editor")%></a></a></li>				 
					<li class="v_time">Ê±¼ä£º<%=year(rs("UpdateTime"))%>-<%=month(rs("UpdateTime"))%>-<%=day(rs("UpdateTime"))%> <span class="txt_gray"> </span></li>	                          
					<li class="v_tags">ä¯ÀÀ£º<%=rs("hits")%></li>
					</ul>
				  </div>
				<%
						i=i+1
						if i>10 then exit do
						rs.movenext
						loop
						rs.close
						set rs=nothing%>

</body>

</html>