By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,375 Members | 1,111 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,375 IT Pros & Developers. It's quick & easy.

PHP Shopping Basket

P: n/a
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
Jul 17 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.