shopping cart to order and orderline

[ceanth]

Hi all i have a shopping cart which i need to now transfer to order and orderline table.

Ok so the cart has "cartid, custid, productid, qty"

Now i need to add to order:

custid and date which should be ok to do

Ok now the problem is how can i tranfer the cart information "which is essentially orderlines" into orderline table.

How can i obtain each row from the cart table and put into the orderline? orderline would be the order number which just got entered and the product no and qty from the cart.

[ddeocampo]

I don't know where you got the shopping cart program but typically the shopping cart information (products people order, qty, price, etc) are stored in cookies. Find out from the maker of that shopping cart program what variables they use so that you can retrieve the info from those cookie variables and transfer the information to your code.