This looks like an order-lineitem situation, which I would imagine would
look like this:
ORDERS
ORDER_ID
CUSTOMER_ID
ORDER_DATE
LINEITEM
ORDER_ID
PRODUCT_ID
LINEITEM_QUANTITY
At 02:00 PM 6/18/2001 -0500, you wrote:
>I have a design problem I was hoping some of you could help me out
>with. I am writing a shopping
>cart system (as if there wasn't enough already) and I have one problem
>that has me stumped.
>
>A person can order more than one item of course. So let's say they order
>a kite and some string.
>Both of these have product numbers, and the overall order has an order
>number. I am trying to
>figure out how to design a table ( or tables ) so I can keep track of the
>different products that
>are ordered during one order. I need to keep track of the product number,
>quantity, and price
>for that product. For instance:
>
>Order # Products
>------------- ------------------
>11111 222 : Qty 1: 12.00 # 333 : Qty 2 : 14.00
>
>That is order number 11111 and that person ordered one of product # 222 @
>12.00 and 2 of product # 333 @14.00.
>
>I would appreciate any assistance any of you might be able to offer. If I
>wasn't clear enough, let
>me know and I will try and explain it better.
>
>Thanks.
>
>Jeff Jones
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
John Meyer
[EMAIL PROTECTED]
Programmer
If we didn't have Microsoft, we'd have to blame ourselves for all of our
programs crashing
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php