I hope someone has an idea where to head with this one....
I have the following code for Brands working well..
<!-- get mfg from products-->
<% Dim Mfgset,sqlstr,myconn
sqlstr= "select distinct ucase(mfg) as mfg from products where mfg > ' ' "
Set Mfgset = myconn.Execute(sqlstr)
While NOT Mfgset.EOF
response.Write "<img src='Images/Spacing.gif' width='4' height='1'><img src='Images/art_dot.gif' width='5' height='5' align='absmiddle'><img src='Images/Spacing.gif' width='4' height='1'><a HREF='shopquery.asp?mfg=" & server.urlencode(Mfgset("mfg")) & addwebsesslink & "' class='sidelinks'>" & Mfgset("mfg") & "</a><BR>"
set Mfgset =nothing
I would like to be able to have the page show the categories that that brand is in, then select the category to show the sub-cat or the products accordingly etc.
Basically, I have categories and want to show brands by category.
Any ideas would be really helpful thanks heaps in advance.