[ic] Categories - one product in multiple categories

[cfm@maine.com]

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

products table
sku  product
1	Foo
2	Bar
3	Gletch

categories table
cc	description
1	Big shiny things
2	Dull drab things
3	Everything else
4	The universe

relations
sku	cc
1	1	# Foo is a big shiny thing
1	4	# everything is in The Universe
2	2
2	4
3	3
3	4


Pandora's box....


-- 

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