<table border="0" width="100%" id="table1" cellspacing="0" cellpadding="0" height="8"><tr><td></td></tr></table>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td align="center"><table width="100%" border="0" cellpadding="0" cellspacing="0">
      <tr>
        <td width="11" background="images/pnew-bg1_r1_c3.gif"><img name="pnewbg1_r1_c1" src="images/pnew-bg1_r1_c1.gif" width="11" height="31" border="0" id="pnewbg1_r1_c1" alt="" /></td>
        <td background="images/pnew-bg1_r1_c3.gif"><strong>&gt;推荐商品</strong></td>
        <td width="9" align="right" background="images/pnew-bg1_r1_c3.gif"><img name="pnewbg1_r1_c5" src="images/pnew-bg1_r1_c5.gif" width="9" height="31" border="0" id="pnewbg1_r1_c5" alt="" /></td>
      </tr>
    </table>
        <table width="100%" border="0" cellpadding="0" cellspacing="0">
          <tr>
            <td width="2" background="images/l-bg2_r1_c1.gif"><img name="lbg2_r1_c1" src="images/l-bg2_r1_c1.gif" width="2" height="1" border="0" id="lbg2_r1_c1" alt="" /></td>
            <td align="center"><table width="98%" border="0" cellpadding="0" cellspacing="0">
                <tr>
                  <td><table border="0" width="100%" id="table2" cellpadding="3">
                    <tr>
                      <td width="280" align="center"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
                          <% 
SQL = "Select Top 1 * From [BJX_goods] where bestbook=1 order by bookid desc"
Set Rs = Conn.Execute(SQL)
For i=1 to 1
If Rs.Eof Then Exit For
bookid = Rs("bookid")
bookpic = Rs("bookpic")
shichangjia = Rs("shichangjia")
huiyuanjia = Rs("huiyuanjia")
chengjiaocount = Rs("chengjiaocount")
liulancount = Rs("liulancount")
bookad = "【"&Rs("bookad")&"】"
if len(trim(rs("bookname")))>18 Or len(trim(rs("bookad")))>10 then
bookname = left(trim(Rs("bookname")),18)&" "&left(trim(rs("bookad")),10)&".."
else
bookname = Rs("bookname")&" "&trim(rs("bookad"))
end if
%>
                          <tr>
                            <td width="25%" height="23" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                                <tr>
                                  <td align="center" height="275"><table onmouseover="this.style.backgroundColor='#FF4FAE'" onmouseout="this.style.backgroundColor=''" width="260" height="260" cellspacing="1" cellpadding="2" bgcolor="#e1e1e1" border="0">
                                      <tbody>
                                        <tr>
                                          <td bgcolor="#ffffff" align="center"><%if rs("bookpic")="" then 
	response.write "<div align=center><a href=product.asp?Iheeoid="&rs("bookid")&" target=_blank><img src=images/emptybook.gif width=75 height=75 border=0></a></div>"
	else%>
                                              <a href="product.asp?Iheeoid=<%=rs("bookid")%>" target="_blank"><img src="<%=trim(rs("bookpic"))%>" width="256" height="256" border="0" align="absmiddle" /></a>
                                              <%end if%>
                                          </td>
                                        </tr>
                                      </tbody>
                                  </table></td>
                                </tr>
                                <tr>
                                  <td align="center"><a class="a4" href="product.asp?Iheeoid=<%= bookid %>" target="_blank"><font color="#FF6600"><%= bookName %></font></a><br />
                                    市场价：<s><%=formatnumber(rs("shichangjia"),0)&"元"%></s>　会员价：<font color="#FF3300"><%=formatnumber(rs("huiyuanjia"),0)&"元"%></font><br />
                                    累计售出：<font color="#FF3300"><%=rs("chengjiaocount")%></font>件　关注热度：<font color="#FF3300"><%=rs("liulancount")%></font>次</td>
                                </tr>
                            </table></td>
                            <% 
				Rs.Movenext
				 %>
                          </tr>
                          <% 
			Next
			Rs.Close
			  %>
                      </table></td>
                      <td><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
                          <% 
SQL = "Select Top 8 * From [BJX_goods] where bestbook=1 order by bookid desc"
Set Rs = Conn.Execute(SQL)
For i=1 to 2
If Rs.Eof Then Exit For
bookid = Rs("bookid")
bookpic = Rs("bookpic")
shichangjia = Rs("shichangjia")
huiyuanjia = Rs("huiyuanjia")
if len(trim(rs("bookname")))>10 then
bookname = left(trim(Rs("bookname")),8)&".."
else
bookname = Rs("bookname")
end if
%>
                          <tr>
                            <td width="25%" height="23" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                                <tr>
                                  <td align="center" height="110"><table onmouseover="this.style.backgroundColor='#FF4FAE'" onmouseout="this.style.backgroundColor=''" width="90" height="90" cellspacing="1" cellpadding="3" bgcolor="#e1e1e1" border="0">
                                      <tr>
                                        <td width="90" height="90" bgcolor="#ffffff" align="center"><%if bookpic = "" then 
response.write "<a href='product.asp?Iheeoid="&rs("bookid")&"' target=_blank><img src='images/emptybook.gif' width='75' height='75' border='0'></a>"
else%>
                                            <a href="product.asp?Iheeoid=<%= bookid %>" target="_blank"><img src="<%=trim(bookpic)%>" width="84" height="84" border="0" align="absmiddle" /></a>
                                            <%end if%></td>
                                      </tr>
                                  </table></td>
                                </tr>
                                <tr>
                                  <td align="center"><a class="a4" href="product.asp?Iheeoid=<%= bookid %>" target="_blank"><font color="#FF6600"><%= bookName %></font></a><br />
                                    市场价：<s><%=formatnumber(rs("shichangjia"),0)&"元"%></s><br />
                                    会员价：<font color="#FF3300"><%=formatnumber(rs("huiyuanjia"),0)&"元"%></font></td>
                                </tr>
                            </table></td>
                            <%
Rs.Movenext
If Rs.Eof Then Exit For
bookid = Rs("bookid")
bookpic = Rs("bookpic")
shichangjia = Rs("shichangjia")
huiyuanjia = Rs("huiyuanjia")
if len(trim(rs("bookname")))>10 then
bookname = left(trim(Rs("bookname")),8)&".."
else
bookname = Rs("bookname")
end if
%>
                            <td width="25%" height="23" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                                <tr>
                                  <td align="center" height="110"><table onmouseover="this.style.backgroundColor='#FF4FAE'" onmouseout="this.style.backgroundColor=''" width="90" height="90" cellspacing="1" cellpadding="3" bgcolor="#e1e1e1" border="0">
                                      <tr>
                                        <td width="90" height="90" bgcolor="#ffffff" align="center"><%if bookpic = "" then 
response.write "<a href='product.asp?bjxGid="&rs("bookid")&"' target=_blank><img src='images/emptybook.gif' width='75' height='75' border='0'></a>"
else%>
                                            <a href="product.asp?Iheeoid=<%= bookid %>" target="_blank"><img src="<%=trim(bookpic)%>" width="84" height="84" border="0" align="absmiddle" /></a>
                                            <%end if%></td>
                                      </tr>
                                  </table></td>
                                </tr>
                              <tr>
                                  <td align="center"><a class="a4" href="product.asp?Iheeoid=<%= bookid %>" target="_blank"><font color="#FF6600"><%= bookName %></font></a><br />
                                    市场价：<s><%=formatnumber(rs("shichangjia"),0)&"元"%></s><br />
                                    会员价：<font color="#FF3300"><%=formatnumber(rs("huiyuanjia"),0)&"元"%></font></td>
                              </tr>
                            </table></td>
                            <%
Rs.Movenext
If Rs.Eof Then Exit For
bookid = Rs("bookid")
bookpic = Rs("bookpic")
shichangjia = Rs("shichangjia")
huiyuanjia = Rs("huiyuanjia")
if len(trim(rs("bookname")))>10 then
bookname = left(trim(Rs("bookname")),8)&".."
else
bookname = Rs("bookname")
end if
%>
                            <td width="25%" height="23" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                                <tr>
                                  <td align="center" height="110"><table onmouseover="this.style.backgroundColor='#FF4FAE'" onmouseout="this.style.backgroundColor=''" width="90" height="90" cellspacing="1" cellpadding="3" bgcolor="#e1e1e1" border="0">
                                      <tr>
                                        <td width="90" height="90" bgcolor="#ffffff" align="center"><%if bookpic = "" then 
response.write "<a href='product.asp?bjxGid="&rs("bookid")&"' target=_blank><img src='images/emptybook.gif' width='75' height='75' border='0'></a>"
else%>
                                            <a href="product.asp?Iheeoid=<%= bookid %>" target="_blank"><img src="<%=trim(bookpic)%>" width="84" height="84" border="0" align="absmiddle" /></a>
                                            <%end if%></td>
                                      </tr>
                                  </table></td>
                                </tr>
                              <tr>
                                  <td align="center"><a class="a4" href="product.asp?Iheeoid=<%= bookid %>" target="_blank"><font color="#FF6600"><%= bookName %></font></a><br />
                                    市场价：<s><%=formatnumber(rs("shichangjia"),0)&"元"%></s><br />
                                    会员价：<font color="#FF3300"><%=formatnumber(rs("huiyuanjia"),0)&"元"%></font></td>
                              </tr>
                            </table></td>
                            <%
Rs.Movenext
If Rs.Eof Then Exit For
bookid = Rs("bookid")
bookpic = Rs("bookpic")
shichangjia = Rs("shichangjia")
huiyuanjia = Rs("huiyuanjia")
if len(trim(rs("bookname")))>10 then
bookname = left(trim(Rs("bookname")),8)&".."
else
bookname = Rs("bookname")
end if
%>
                            <td width="25%" height="23" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                                <tr>
                                  <td align="center" height="110"><table onmouseover="this.style.backgroundColor='#FF4FAE'" onmouseout="this.style.backgroundColor=''" width="90" height="90" cellspacing="1" cellpadding="3" bgcolor="#e1e1e1" border="0">
                                      <tr>
                                        <td width="90" height="90" bgcolor="#ffffff" align="center"><%if bookpic = "" then 
response.write "<a href='product.asp?bjxGid="&rs("bookid")&"' target=_blank><img src='images/emptybook.gif' width='75' height='75' border='0'></a>"
else%>
                                            <a href="product.asp?Iheeoid=<%= bookid %>" target="_blank"><img src="<%=trim(bookpic)%>" width="84" height="84" border="0" align="absmiddle" /></a>
                                            <%end if%></td>
                                      </tr>
                                  </table></td>
                                </tr>
                              <tr>
                                  <td align="center"><a class="a4" href="product.asp?Iheeoid=<%= bookid %>" target="_blank"><font color="#FF6600"><%= bookName %></font></a><br />
                                    市场价：<s><%=formatnumber(rs("shichangjia"),0)&"元"%></s><br />
                                    会员价：<font color="#FF3300"><%=formatnumber(rs("huiyuanjia"),0)&"元"%></font></td>
                              </tr>
                            </table></td>
                            <%
Rs.Movenext
%>
                          </tr>
                          <%
Next
Rs.Close
%>
                      </table></td>
                    </tr>
                  </table>
                  </td>
                </tr>
            </table></td>
            <td width="2" align="right" background="images/l-bg2_r1_c3.gif"><img name="lbg2_r1_c3" src="images/l-bg2_r1_c3.gif" width="2" height="1" border="0" id="lbg2_r1_c3" alt="" /></td>
          </tr>
        </table>
      <table width="100%" border="0" cellpadding="0" cellspacing="0">
          <tr>
            <td width="8" background="images/l-bg3_r1_c2.gif"><img name="lbg3_r1_c1" src="images/l-bg3_r1_c1.gif" width="8" height="6" border="0" id="lbg3_r1_c1" alt="" /></td>
            <td background="images/l-bg3_r1_c2.gif"><img name="lbg3_r1_c2" src="images/l-bg3_r1_c2.gif" width="7" height="6" border="0" id="lbg3_r1_c2" alt="" /></td>
            <td width="9" align="right" background="images/l-bg3_r1_c2.gif"><img name="lbg3_r1_c4" src="images/l-bg3_r1_c4.gif" width="9" height="6" border="0" id="lbg3_r1_c4" alt="" /></td>
          </tr>
      </table></td>
  </tr>
</table>
<table border="0" width="100%" id="table1" cellspacing="0" cellpadding="0" height="8"><tr><td></td></tr></table>

