Select Product Category & Sub Category to search   <% if Request.QueryString("Select_Product")<>"" then mySQL="select * from tblCategory where CategoryID="& Request.QueryString("Select_Product") myRs.Open mySQL,myConn,3 prdName=myRs.Fields("CategoryName") myRs.Close %> <% end if %> ">   Product Category <% mySQL="select * from tblCategory order by CategoryID ASC" myRs.Open mySQL,myConn,3 do while not myRs.EOF id=myRs.Fields("CategoryID") productName=myRs.Fields("CategoryName") %> <%=productName%> <% myRs.MoveNext Loop %> <% myRs.Close %> <%=prdName%>   View Entire List , or   Select the sub categories from the list         Sub-Product Category Note :- To select multiple options, Press Control (Ctrl) or Shift button of the Keyboard and then select the sub categories.  <% mySQL="select * from tblSubCategory where CategoryID="& Request.QueryString("Select_Product") myRs.Open mySQL,myConn,3 do while not myRs.EOF subIDs=myRs.Fields("SubCategoryID") subProduct=myRs.Fields("SubCategoryName") %> <%=subProduct%> <% myRs.MoveNext Loop ' end if %>     <% if Request("Select_Product") <> "" then %> <% else %> <% end if %>