[Resolved] Help with Mysql query

[JLW]

I am working on a shopping cart. When a user submits an order they can have as many items as they want in their shopping cart. Each item that they order will be inserted separately into the database. So each item has a different item number. I need to be able to have one number that will identify the order. It can't be auto-increment because some records may have the same order number. So basically I need to have a number for each transaction that will increase each time a new order is placed, but allow all of the items for that order to have the same number. Does that make sense? Any ideas?😕

[Pig]

Your data is not normalized. You need 2 tables. One for the cart, and one for the items. The cart table will hold everything unique to the cart, eg: the user making the purchases. The second table holds the purchases. It has a row for each item, and the id of the current entry in the carts table.
eg:
cart_id | item_id
1 | 1
1 | 2
1 | 3

[JLW]

Thanks alot!