Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › eCart › eCart General / Announcements › items set up by color

items set up by color

Thread began 5/13/2009 2:55 pm by JBWebWorks | Last modified 10/15/2009 8:48 am by JBWebWorks | 11881 views | 37 replies

5/15/2009 7:10 amJBWebWorks

thanks Ray
very good tutorial
But even with the correct JOIN, i think my database setup is not correct.

I use the WHERE itemCATID = 3 to go to the products page of all category 3 products.
On that page is where i want a list/menu for each item, where the shopper can pick the color of the product/products to add to the cart. In order to dynamically populate the list/menu with the proper choices of colors for that product, i must have a correct recordset.

So i think in my items table, i need a column of colorgroupID and a color table with colorgroupID saying what colors are available for that colorgroupID.

Am i on the right track?

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.