title: How to create a database model with multiple products in one order
body: <p>I'm setting up a model of an SQL database that keeps track of an order with multiple products that have a certain quantity.</p>
  
  <p>The table has to have a key value that is specific for that order and never repeats anywhere else in the table.</p>
  
  <p>I'm thinking of making a row that has an orderID as key value, then an Order tab that has the productID and quantity like this "ProductID-Quantity" so that it can be placed in one cell. The tricky part is taking multiple different products in this row. It can be done inserting all the products with their quantities in one cell like this:</p>
  
  <pre><code>"1100-3, 1500-1, 1600-8"
  </code></pre>
  
  <p>So this is one cell with three products ordered 3, 1 and 8 times. Reading it in in PHP seperating them with a comma and a dash.</p>
  
  <p>Is there any way to do this more effectively?</p>