info_deflationary.asp

asp商城之王

<table width="350" height="141" border="0" cellpadding="3" cellspacing="0">
  <%set rs=server.createobject("adodb.recordset")
			rs.open "select Top 3 * from sh_chanpin where tejiabook=1 and bestbook=1 order by adddate desc",conn,1,1
			if rs.recordcount=0 then 
			response.write "<tr><td>　暂无推荐特价</td></tr>"
			else
		%>
  <tr>
    <%while not rs.eof%>
    <td width="342" height="141" align=center><table width="112" height="135"  border="0" cellpadding="0" cellspacing="0">
        <tr>
          <td height="60" colspan="8"><img src="images/huang1.gif" width="72" height="60"></td>
        </tr>
        <tr>
          <td width="45"><a href=list.asp?id=<%=rs("bookid")%> target="_blank">          </a></td>
          <td width="75"><a href=list.asp?id=<%=rs("bookid")%> target="_blank"><img src="<%=trim(rs("bookpic"))%>" alt="<%=trim(rs("bookname"))%>" width="75" height="75" border=0></a></td>
          <td width="36">&nbsp;</td>
        </tr>
      </table></td>
    <%			rs.movenext
			wend
		%>
  </tr>
  <%
		end if
		rs.close
		%>
</table>