<TABLE WIDTH="100%" BORDER="0" CELLSPACING="0" CELLPADDING="0" align="center" >
  <tr> 
   <td height="25" class=table-xia align="center" ><FONT COLOR=<%=bgclr1%>> <b><% = strsorts %>推荐新品</b></font></td>
              <td  align="right" WIDTH=30 class=table-xia ><a href="recommend.asp"><font color="<%=bgclr1%>">更多</font></a></td>
           </tr>
              <%
			 set rs=server.CreateObject("adodb.recordset")
		  rs.open "select top 10 id,name,viewnum from product where  recommend=1 order by adddate desc",conn,1,1
			  if rs.eof and rs.bof then
			  response.write "<TR><TD height=20 bgcolor=#ffffff> align=center>暂无此类商品"
			  else
			  i=0 
			  do while not rs.eof %>
			  <TR>
                <TD height="20"  COLSPAN="2" >&nbsp;&nbsp;<img src='images/dot11.gif' border=0><FONT COLOR=#333333> <%=trim(rs("name"))%></font>
			
				</TD>
              </TR>
				<%
				i=i+1
			  if i>=20 then exit do
			  rs.movenext
			  loop 
                          end if
			  rs.close
			  set rs=nothing
			  %>
            </TABLE>
