VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-ASP Shopping Cart Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 Customization
 brands with category breaks
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

rustytec
VP-ASP New User

Australia
113 Posts

Posted - October 18 2005 :  00:39:42  Show Profile  Reply with Quote
Hi,
I hope someone has an idea where to head with this one....

I have the following code for Brands working well..
 	<div align="left">
<!-- get mfg from products-->
<% Dim Mfgset,sqlstr,myconn

ShopOpenDatabase 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>"
Mfgset.movenext
Wend

Mfgset.close
set Mfgset =nothing
%>
</div>


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.

Any ideas?

Basically, I have categories and want to show brands by category.

Any ideas would be really helpful thanks heaps in advance.
:)


Russ
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000