%
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 = ("tank.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
Tankards
Tankards make great birthday gifts, weddings gifts (best man) or to mark any special occasion. All the tankards we stock are made from pewter and made by The English Pewter Company based in Sheffield, England. Pewter is extremely versatile and still adds grace and elegance to contemporary and social occasions. All English Pewter Co tankards are specially packaged in presentation boxes.
<% closedb %>