<% OpenDB() rsfound = false cat = 1 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 = ("pipes.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 %> Bonds of London : Product Catalogue : Pipes : We have pipes for the beginner, the experienced, collectors and carry all the famous brands.

Product Catalogue

Pipes


For centuries Pipe smoking has been a wonderful way to relax and unwind, and now it is becoming increasingly popular, partly due to the higher cost of smoking cigarettes. We have pipes for the beginner, the experienced and collectors and carry all the famous brands from Dunhill, Peterson, Falcon, James Upshall just to name a few and we have a range of water pipes and hookahs.