[ic] gouping items

[scott andreas]

cfm@maine.com wrote:
> 
> On Mon, Feb 05, 2001 at 05:59:22AM -0800, johny brabo wrote:
> > Hello,
> > Maybe my last question wasn't very clear since I
> > didn't get an answer.
> >
> > I am looking for a simple way to show an item and
> > links to parts of that item, so eg. I show a computer
> > and beneath it I show links to the parts. People can
> > Buy the whole computer, but they also can see what
> > screen it has, what memory and so on...
> >
> > The "order groups"-function doesn't seem to fit my
> > needs since there is no need to sell multiple items at
> > once. Also "accesoires" isn't really what I need I
> > guess. Can someone hint me to a solution?
> 
> TABLE assemblies (
>   code varchar
>   part varchar
> )
> 
> Where code is the big item and "part" is the code
> for the item that goes into it.  One code in your
> products table can have any number of records in
> assemblies.  I'm presuming that each "part" in assembly
> is also in your products table so you can pull the additional
> information you need.  Alternatively, denormalize
> assemblies and add the fields to make display easier/faster.
> 
> SELECT * FROM products WHERE code=[item_code]; # display item
> 
> SELECT * FROM assemblies WHERE code=[item_code]; # for each loop
> 
> 
> >
> > Any small advice is appreciated
> >
> > __________________________________________________
> > Get personalized email addresses from Yahoo! Mail - only $35
> > a year!  http://personal.mail.yahoo.com/
> >
> > _______________________________________________
> > Interchange-users mailing list
> > Interchange-users@lists.akopia.com
> > http://lists.akopia.com/mailman/listinfo/interchange-users
> 
> --
> 
> Christopher F. Miller, Publisher                             cfm@maine.com
> MaineStreet Communications, Inc         208 Portland Road, Gray, ME  04039
> 1.207.657.5078                                       http://www.maine.com/
> Content management, electronic commerce, internet integration, Debian linux
> 
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@lists.akopia.com
> http://lists.akopia.com/mailman/listinfo/interchange-users

Here's an idea.

Have the user select the computer. The cart will display the computer
with related items all checked beneath it. If the user unchecks the
related item the cart will recalculate itself subtracting the unneeded
item. Or you can start with a base model and add related items to it in
the cart. This way the user check the box and adds parts to the computer
hince building a computer.

Within the cart the user can click on the  description hyperlink to view
what that item actually is

Just a suggestion
-- 
J. Scott Andreas :)
Programmer/Webintegrator 
e-mail: scotta@homer.learnserv.com
phone: 1-800-877-9378 ext. 146
fax: (541) 744-2056
      ---    __o
     ---   _-\<,_        
      --- (_)/ (_)