I was wondering if a experienced VBScripter might be able to help me with something I'm trying to figure out.
What I'm trying to do is call product categories from a access DB, which I can do fine in a loop. And then have them display in a hyperlink and then click the hyperlinks call the page and then output the sub catagories to hyperlinks, etc, etc. till where at each indivdual product.
Here is what I have so far.
<table cellspacing=0 cellpadding width=292 height=238 border=0>
<tr><td align=center valign=middle>
<%this_fullcat = replace(request("cat"),"%20%"," ")
this_id = request("id")
set rs = db.execute("SELECT * FROM catalog_categories WHERE parent='-' ORDER BY category")
while not rs.eof
category = rs("category")%>
<div style="text-align: center; padding-top: 50pt;">
<a href="catalog-working.html?cat=<%=category%>\<%=subcategory%>" class="catnav"><%=category%></a>
I also have this code that calls the sub-catagory that I need to nest some how with that href tag I'm guessing?
set rs2 = db.execute("SELECT * FROM catalog_categories WHERE parent='" & replace(category,"'","''") & "' ORDER BY category")
while not rs2.eof
subcategory = rs2("category")
id = rs2("id") %>
<a href="catalog-new.html?cat=<%=category%>\<%=subcategory%>&id=<%=id%>" class="catnav"><%=subcategory%></a><br>
Any assistance would be greatly appreicated.