|
|
|
|
Hi Everyone,
I would like to have a MySQL table of all the
orders, with the unique ID being the order number. It would contain
information just about the order such as name, address, payment method, date,
etc.
Then I would like a second table for items in the
order. It will have a column with the order number it is from, and the
details of the item, price, etc.
How can I add these to a MySQL database from the
receipt / report pages? Would this best be done in the etc/report
page?
Thanks in advance for your help!
Brian Allen
|