[eluser]umbongo[/eluser]
I want to store the contents of an order in a database (mysql). For each order i wish to store each product number, each price at time of order, and the quantity of each item.
Do i have to do it like this;
Code:
<header>
Order_id | Prod_ids | prices | qtys
<contents>
[order_id] | [P_id1, P_id2...] | [price1, price2...] | [qty1, qty2...]
Or is there a better way where each item can have its own field??