Product Catalogue
Pipe Accessories
For all your pipe smoking needs we have everything you need from pipe tools, leather pouches to carry your pipe and tobacco, pipe cleaners and filters, pipe stands and tobacco jars.
% OpenDB() rsfound = false cat = request("cat") if not isnumeric(cat) then response.End() end if sid = request("sid") if sid <> "" then if not isnumeric(sid) then response.End() end if end if cid = request("cid") if cid <> "" then if not isnumeric(cid) then response.End() end if end if pid = ("pipeacc.asp") If cat <> "" Then If sid <>"" then sql = "select products.*,categories.* from (products Inner join categories ON products.cid=categories.catid) where cid = "&cat&" AND subcatid = "&sid&" order by productid desc" Else sql = "select products.*,categories.* from (products Inner join categories ON products.cid=categories.catid) where cid = "&cat&" order by productid desc" End If rs.Open sql,conn,1,3 If not rs.eof then categoryname = rs("categoryname") End If End If %>
For all your pipe smoking needs we have everything you need from pipe tools, leather pouches to carry your pipe and tobacco, pipe cleaners and filters, pipe stands and tobacco jars.