[ic] gouping items
Mon, 5 Feb 2001 09:13:32 -0500
On Mon, Feb 05, 2001 at 05:59:22AM -0800, johny brabo wrote:
> 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 (
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
Christopher F. Miller, Publisher firstname.lastname@example.org
MaineStreet Communications, Inc 208 Portland Road, Gray, ME 04039
Content management, electronic commerce, internet integration, Debian linux