I have the following problem with an e-commerce site that I am building using php and database MySQL.
When the user has select items to buy then clicks on the button to checkout which are stores in the database in order the owner of the shop to send the specific items to the clients.
The tables that stores the information for the orders is called Orders with the following fields:
OrderID,customerID,itemID,amount,date_order and quantity.
The problem I have is that if the cutomer buy more than one item how they are going to be stored in the database,If for the same order of the customer I store two items in the itemID field it will cause problem with the normalisation.
Could please anyone suggest how I can store to the database many item for the same order?