<% 'Set rs=conn.execute("select * from product Where IsBest=true ORDER BY ProductID DESC") Set rs=conn.execute("select * from product Where SortID IN (SELECT SortID FROM Industry WHERE ParentID IN (SELECT SortID FROM Industry WHERE SortName='龙氏颈椎保健枕')) and IsBest=true ORDER BY ProductID DESC") if rs.eof And rs.bof then Response.Write " 您没有推荐或上传龙枕产品！ " else sortclass=Conn.Execute("SELECT SortName FROM Industry WHERE SortID ="&rs("SortID")) nameclass=Conn.Execute("SELECT SortName FROM Industry WHERE SortID IN (SELECT ParentID FROM Industry WHERE SortID ="&rs("SortID")&") ") %> <%i=0 do while not rs.eof %> <% i=i+1 rs.movenext 'if i=15 then exit do loop %> " href="ShowPhoto.asp?ID=<%=rs(0)%>&sortclass=<%=sortclass(0)%>&sortname=<%=nameclass(0)%>" target="_blank">" src="<%=rs("PicPath")%>" height="160" border="0"/> <% end if rsclose() %>