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-Cart StoreFront Customer Forum

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

 All Forums
 VPCart Forum
 Mfg Pulldown Menu Creation
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

VP-ASP New User

61 Posts

Posted - December 10 2004 :  15:09:28  Show Profile  Reply with Quote
I am looking to make a pulldown menu that will display all Manufacturers, and upon choosing will display all products by that Manufacturer (much like the Category pulldown). Would this have to be accomplished by creating a new table of manufacturers for the lookup or can the SQL search use the products table with Mfg is specified?

I tried to modify the Category search pulldown sub but I couldn't get it to work correctly.

Any help would be appreciated!

Senior Member

United Kingdom
1898 Posts

Posted - December 10 2004 :  17:52:50  Show Profile  Visit devshb's Homepage  Reply with Quote
you wouldn't need to create a new table (unless you wanted to give the descriptions in the poplist a different set of values to the products' mfg values)

you'd just need to query the distinct products.mfg values and then loop around those distinct rows printing a dynamic poplist.

you might also need to change some of the product-querying related files such as shopproductcreatesql.asp to allow the new/extra mfg parameter, but you might not need to; it depends on where you want to place the poplist and how you want it to be used (ie whether you want it on the detailed-search form, on the product-results/summary pages, or on a side-panel, or a combination of those things)

Simon Barnaby
[email protected]
Web Design, Online Marketing and VPASP addons
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000