[ic] Categories - one product in multiple categories

[cfm@maine.com]

On Fri, Mar 02, 2001 at 05:35:28PM -0700, Ryan Hertz wrote:
> 
> >cfm@maine.com wrote:
> > >
> > > On Fri, Mar 02, 2001 at 12:30:43PM -0800, nwcorp@helpwizard.com wrote:
> > > > Does anyone know the magic trick for allowing one product to appear in
> > > > multiple categories?    Can't seem to find any info in the .pdf files or
> > > > here among the users.
> > >
> > > keep the list of categories in which any particular product belongs
> > > in a separate table and JOIN
> >
> >Alrternatively, a somewhat simpler way of doing this is to set up
> >multiple category columns
> >
> >eg
> >
> >sku     desc    cat_1   cat_2   cat_3
> >1               this    none    blue
> >2               that    all     red
> >3               other   all     blue
> 
> Couldn't you just have:
> 
> sku     desc    category        foobar
> 10      Voop    can,bottle      blah

Voop?  :-)

Is that available in tall boys or just 16 oz cans?

-- 

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