<% OpenDB() id = request("id") cid =request("cid") if not isnumeric(id) then response.end end if if not isnumeric(cid) then response.end end if 'sql = "select * from categories where catid = "&cid&"" 'rs.Open sql,conn,1,1 'If not rs.eof then ' catname = rs("categoryname") 'End If 'rs.close sql = "select products.*, categoryname from products left join categories on products.cid = categories.catid where productid = "&id&"" rs.Open sql,conn,1,1 catname = rs("categoryname") %> <%= catname & " : " & rs("prodbrand") & " : " & rs("productname") %> Bonds of London : Product Catalogue , <%= rs("productname") %>"/> , <%= rs("productname") %>"/>

Product Catalogue

<%= catname %>

<% If not rs.eof then set rrs = server.createobject("adodb.recordset") %>
">
)" title="<%= rs("productname") %>"> 
" alt="<%= rs("productname") %>" class="item" />

<%= rs("prodbrand")%>

<%= rs("productname") %>

<%= rs("productinfo") %> <%= formatcurrency(rs("productprice")) %>

Order Quantity? <%if rs("hascolours") = "Y" Then%> <%end if%> <%if rs("hassizes") = "Y" Then%> <% end if %>

<% End If %>