How to insert multiple records of same table

[yandoo]

Hi there,

 

Is there a way to insert multiple records of the same table at the same time????

 

In my shop each time a customer purchases a type of product a new order is submitted detailing: orderID, productID, CustomerID and Qty.

 

In their cart at the point of purchase they may have more than one type of product and quantiies for each, in the carts. In this situation i think i need to insert an order for each type of product in the same form...

 

Is it possible to do this???

 

Thanks

 

 

[hitman6003]

You can, however it is mysql specific...

 

INSERT INTO tablename (column1, column2) VALUES ('value1', 'value2), ('value3', 'value4'), ('value5', 'value6');

[drax]

So you could have an order that looks like

 

orderId=1bb

 

customerID =Joe1

 

ProductID = 9af

quantity = 2

 

ProductID = 6az

quantity = 1

 

etc?

 

that would all appear in a single instance of the cart?

[yandoo]

yes thats right,

 

how can i over come this please??