%
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 = ("hipflask.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
Hip Flasks
Hip Flasks make great birthday gifts, wedding gifts or to mark any special occasion. We stock a large range of quality pewter flasks from The English Pewter Company and leather stainless steel hip flasks which are available in a wide range of sizes and styles. All hip flasks come in presentation boxes.
<% closedb %>