%
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 = ("knives.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
Swiss Army Knives & Leatherman Pocket Tools
We stock a comprehensive collection of Victorinox Original Swiss Army Knives. Today, this ingenious, award winning multi-tool is popular throughout the world because of its high quality, versatility and excellence in design. The 'Swiss Army Knife' renders countless services to millions of people every day and like a watch, is an indispensable companion to them. We also carry the Leatherman multi-tools range, the Leatherman brand name is synonymous with quality and innovation and is the world leader in multi-tools.
<% closedb %>