<%
SQL="select top 15 title,movieid from moviedetail order by hits desc"
Set rsn=conn.execute(SQL)
movie_j=1
Do While Not rsn.eof
%>
<%If movie_j<10 Then response.write(" ")%><%=movie_j%>. <%=Left(rsn(0),20)%><%
rsn.movenext
movie_j=movie_j+1
Loop
%>