<!--#include file="conn.asp"--> 
<table border="0" cellpadding="0" cellspacing="0" width="27%">
  <% set rsr=server.createobject("adodb.recordset")
sql="Select top 10 * from pic where isgood=1 order by id Desc"
rsr.open sql,conn,1,1 
if rsr.eof and rsr.bof then
%>
  <li>没有推荐作品 
    <%else%>
    <tr > 
      <td align="center" background="images/zuo-bg.gif"> 
        <div align="left"><img src="images/tuijian.gif" width="203" height="31"></div>
      </td>
    </tr>
    <%do while not rsr.eof%>
    <tr> 
      <td background="images/zuo-bg.gif"> 　<a title="点击：<%=rsr("pichits")%>"   target=_blank href="picshow.asp?id=<%=rsr("id")%>"><%=Left(rsr("picname"),12)%></a> 
        <%if not rsr("pictime") < date then%>
        &nbsp;<img border="0" src="IMAGEs/NEW.gif" title="点击排行中最新发布"> 
        <%end if%>
        <font color="#FF0000"><%=rsr("pichits")%></font></td>
    </tr>
    <%
	rsr.movenext
	loop
	end if
	rsr.close
%>
</table>
