Welcome Guest, Not a member yet? Register   Sign In
Quick Database Q
#1

[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??




Theme © iAndrew 2016 - Forum software by © MyBB