<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="conn.asp"-->
<%
d=1
'打开数据
'have new flashs date
set rsnew = server.createobject("adodb.recordset")
   strsqlnew = "select * from flash order by time desc;"
   rsnew.open strsqlnew,strcon,1,3
'have hot flashs date
set rshot = server.createobject("adodb.recordset")
   strsqlhot = "select * from flash order by hot desc;"
   rshot.open strsqlhot,strcon,1,3
'have path1 showhot flashs
set rs1hot = server.createobject("adodb.recordset")
   strsql = "select * from flash where pathid like '1' and showhot like  '1'  order by id desc;"
   rs1hot.open strsql,strcon,1,3
'have path2 showhot flashs
set rs2hot = server.createobject("adodb.recordset")
   strsql = "select * from flash where pathid like '2' and showhot like  '1'  order by id desc;"
   rs2hot.open strsql,strcon,1,3
'have path3 showhot flashs
set rs3hot = server.createobject("adodb.recordset")
   strsql = "select * from flash where pathid like '3' and showhot like  '1'  order by id desc;"
   rs3hot.open strsql,strcon,1,3
'have path4 showhot flashs
set rs4hot = server.createobject("adodb.recordset")
   strsql = "select * from flash where pathid like '4' and showhot like  '1'  order by id desc;"
   rs4hot.open strsql,strcon,1,3
'have path5 showhot flashs
set rs5hot = server.createobject("adodb.recordset")
   strsql = "select * from flash where pathid like '5' and showhot like  '1'  order by id desc;"
   rs5hot.open strsql,strcon,1,3
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>千纸鹤动漫</title>
<link href="main.css" rel="stylesheet" type="text/css">
</head>

<body topmargin="0">
<table width="167" border="0" align="center" cellpadding="0" cellspacing="0" background="images/bj.gif">
  <tr>
    <td width="178" align="right" valign="top" height="87"> 
      <table width="167" height="20" border="0" cellpadding="0" cellspacing="0">
        <tr> 
          <td width="178" height="20"><map name="FPMap0">
            <area href="list.asp" target="_blank" coords="117, 5, 164, 18" shape="rect"></map><img border="0" src="images/Mtvflash.gif" usemap="#FPMap0"></td>
        </tr>
      </table>
      <table width="167" border="0" cellpadding="0" cellspacing="0">
        <tr>
          <td bordercolor="#F6F6F6">
            <div align="left">
              <TABLE width="166" border="0" cellpadding="0" cellspacing="0" >
              <% do while not(rsnew.eof or err) and d<19 '开始循环 %>
              <tr> 
                <td width="18" height="25" align="center"><img src="images/box2_icon.gif" width="4" height="6"></td>
                <td width="158" height="25"><a href="show.asp?id=<%=rsnew("id")%>" target="_blank"><%=rsnew("name")%></a>(<font color="#FF6600"><%=rsnew("hot")%></font>/<font color="#999999"><%=rsnew("day")%></font>)</td>
              </tr>
              <% d=d+1 
		rsnew.movenext
		 loop%>
            </table>
            </div>
          </td>
        </tr>
      </table>
      
      <table width="70%" height="0" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr>
          <td><img src="images/blank.gif" width="5" height="8"></td>
        </tr>
      </table>
      <table width="167" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr>
          <td></td>
        </tr>
      </table></td>
  </tr>
</table>
</body> 
</html> 
