<%dim i
set rs=server.createobject("adodb.recordset")
sql="select top 10 product.productid,product.title,product.dateandtime,ANclass.Nclass from product,ANclass where product.Nclassid=ANclass.Nclassid and product.classID=1 order by product.productid desc"
rs.open sql,conn,1,1
%>
◎热烈祝贺我公司通过ＩＳＯ９０００质量认证体系！！
<%i=0
do while not rs.eof%>
<%rs.movenext
i=i+1
if i=9 then exit do
loop
rs.close %>
<%
Const prodnum=10
set rs=server.createobject("adodb.recordset")
sql="select * from product where recommend=1 order by productid desc"
rs.open sql,conn,1,1
if not rs.eof then%>
