Hi,
I've been working on a PHP Shopping Basket and have hit a problem.
I wanted update the DB with the contents of the Array which forms the
basket.
This isn't a problem, however i'm unsure how i use Relational Tables
in MySQL.
I have a table called Orders, which stores the CustomersID and also
has an OrderID (this is an autoincrement integer)
I then want to take the OrderID and put it into the OrderItems table
along with the data from the Shopping cart array.
What's the best way to structure this?
All i can think of is a string of messy sql statements.
Any help would be appreciated.
Ian
I've been working on a PHP Shopping Basket and have hit a problem.
I wanted update the DB with the contents of the Array which forms the
basket.
This isn't a problem, however i'm unsure how i use Relational Tables
in MySQL.
I have a table called Orders, which stores the CustomersID and also
has an OrderID (this is an autoincrement integer)
I then want to take the OrderID and put it into the OrderItems table
along with the data from the Shopping cart array.
What's the best way to structure this?
All i can think of is a string of messy sql statements.
Any help would be appreciated.
Ian