<% sql = "select * from img where menu=2 order by xuhao asc" set rs = conn.execute ( sql ) if rs.bof and rs.eof then else i = 1 do while not rs.eof %> <% rs.movenext i = i+1 loop end if rs.close set rs = nothing %>