<table width="199" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td><a href=promotion.asp?userid=<%=userid%>><img src="image/tp/hot2.gif" width="198" height="35" border="0"></a></td>
        </tr>
           <tr><td height=5></td></tr>
         <%set rs = conn.execute("select top 10* from chanpin where userid="&userid&" and cang=0 order by jg2/jg1")
          if not rs.eof then
	  do while not rs.eof
       	 Response.Write("<tr><td height=20>&nbsp;<img src=../image/tp004.gif>&nbsp;<a href=xiangxi.asp?userid="&userid&"&id="&rs("id")&" target=_blank>"&left(rs("mc"),16)&"</a></td></tr>")
        rs.movenext
	loop
	end if
rs.close%>
</table>