% if session("userid")<>"" then logtype="Log out" else logtype="Sign in" end if msg="" newbook=request.querystring("new") catname=request.querystring("catname") cat_type="Lab" if catname<>"" then else catname="Instruments and Experimental Materials" end if subcatname=request.querystring("subcatname") if subcatname="" then set recs=Server.CreateObject("ADODB.Recordset") sql = "select * from products where cat_name='"&catname&"' order by sub_cat_name" recs.open sql,conn,3 if recs.eof<>true then subcatname=recs("sub_cat_name") else msg="Books Not Available for this category" end if end if cpage=request.querystring("cpage") spage=request.querystring("spage") ''''response.write "cpage= "&cpage if cpage="" then cpage=1 end if if spage="" then spage=10 end if set rs=Server.CreateObject("ADODB.Recordset") if newbook="" then sql = "select * from products where cat_name='"&catname&"' and sub_cat_name='"&subcatname&"'order by srno asc" rs.open sql,conn,3 if rs.eof<>true then rs.pagesize=spage rs.absolutepage=cINT(cpage) else msg="Books Not Available for this category" end if else sql = "select * from products where new_book='Yes' " rs.open sql,conn,3 subcatname="" if rs.eof<>true then rs.pagesize=spage rs.absolutepage=cINT(cpage) else msg="Books Not Available for this category" end if end if set rec=Server.CreateObject("ADODB.Recordset") sql = "select * from category where cat_type='Lab'" rec.open sql,conn,3 set reccart=Server.CreateObject("ADODB.Recordset") sql = "select count (prod_code) as citem from cart where userid='"&session("userid")&"'" reccart.open sql,conn,3 if reccart.eof<>true then citem=reccart("citem") else citem=0 end if %>
|
|||||||||||||
![]() |
|||||||||||||
|
|||||||||||||