Main Category <% Set rs1=Server.CreateObject("ADODB.Recordset") sql="select maincat from products group by maincat" rs1.open sql,con,3,2,1 while not rs1.eof %>"><%=rs1("maincat") %> <% rs1.movenext wend rs1.close con.close%>

to

Sub Category <% Set rs1=Server.CreateObject("ADODB.Recordset") sql="select subcat from products group by subcat" rs1.open sql,con,3,2,1 while not rs1.eof %>"><%=rs1("subcat") %> <% rs1.movenext wend rs1.close con.close%>

>>Advance Search

Home | About Us | Quality | Contact | Enquiry |