setting up tables for shopping cart

[spyderco]

I am still quite new with MySQL and need some help getting the basic setup.

I am creating a mini shopping cart and I need some help to make sure I am getting the tables correct. There are 4 tables.

[/code]
--------- ---------
|products| | temp |
--------- ---------
id id
name zip
desc email
price userid
weight shiprice
shipinfo subtotal
total
coupon
ip

----------- -----------
|temporder| |order |
----------- -----------
id id
??? userid
subtotal
total
shipcost
shipmethod
name, address, zip, phone, etc..
[/code]
I have one table for all the products. One temp table which puts their CURRENT order into while they are surfing the site. The order table pulls the information out of the temp table once the order was verified via PayPal's IPN. The temporder table I have no idea what to do with.
I am lost as to how to add all the user's products and qty's to a table without making a new table for each person. That seems very, very costly but I don't know any other way to do it. I need the current items and quantities in both the temporder and the order table (or somehow related so I can pull it back later).

I could in reality make an order table and make duplicate USERID rows and have items/quantities that way and just search for rows that have the USERID in question. This means more reasonable than a new table but depending on the database size, could be costly as well.

Does anyone know of a simple way to add their items/qty's to the table(s)?

In reality, I have no idea how to add the products to the order or temp database. How do I record every product someone purchases? I am so lost.

Any help would be MUCH appreciated.

 

[KarveR]

the temporder table should contain an id assigned to the user (possibly session id), this should also contain product code and quantity.

its then possible to retrieve everything for processing at teh checkout.

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.