PHP Shopping Basket

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

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

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.


Site Timeline