%
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
%>
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.