When more then one item is in cart, success page will result in error message
Error message:
INSERT INTO orderdetails (`DetailsID`, `DetailOrderID`, `DetailItemID`, `DetailArticle`, `DetailItemName`, `DetailItemDesc`, `DetailQuantity`, `DetailPrice`) VALUES (2, 2, 2, 2, 2, 2, 2, 2)
Duplicate entry '2' for key 'PRIMARY'
The problem is, that I could not figure out what to put in as default values when converting DB summary and DB details behaviors to MySQLi. What I entered worked fine if only 1 item (1 item id) was in the cart, but if more than one item id was in the cart, it doesn't work.
I don't need any of the DB entries except for the order_id, so that the order numbers will be unique. Actually I would prefer not to have any information except the order_id due to European privacy laws.