<% Set rss=Server.CreateObject("ADODB.recordset") sql1="select * from pays where id="&request("id") rss.open sql1,conn,2,3 %>

CATALOG <%Set rs=Server.CreateObject("ADODB.recordset") sql="select * from class_pay order by orderID " rs.open sql,conn,1,3 do while not rs.eof set rss=Server.CreateObject("ADODB.recordset") sql1="select * from pays where classid="&rs("orderid") rss.open sql1,conn,1,3 %>     "> <%response.Write(rs("classname"))%>(<%=rss.recordcount%>) <%response.Write " " rs.movenext loop rss.close rs.close %> Choose the category to see products!	Product Information    Products>><%=rss("classname")%> ">" border="0" alt="Lingerie set No1" title=" Lingerie set No1 " width="107" height="87" align="left"> ">Click to enlarge     NAME: <%=rss("title")%>     PRICE: $<%=rss("price")%>     ID:     DESRIPTION     SIZE:   gfds     COLOR:   ddg     TRADEMARK:   dg