yandoo Posted June 30, 2008 Share Posted June 30, 2008 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 Link to comment https://forums.phpfreaks.com/topic/112508-how-to-insert-multiple-records-of-same-table/ Share on other sites More sharing options...
hitman6003 Posted June 30, 2008 Share Posted June 30, 2008 You can, however it is mysql specific... INSERT INTO tablename (column1, column2) VALUES ('value1', 'value2), ('value3', 'value4'), ('value5', 'value6'); Link to comment https://forums.phpfreaks.com/topic/112508-how-to-insert-multiple-records-of-same-table/#findComment-577687 Share on other sites More sharing options...
drax Posted June 30, 2008 Share Posted June 30, 2008 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? Link to comment https://forums.phpfreaks.com/topic/112508-how-to-insert-multiple-records-of-same-table/#findComment-577720 Share on other sites More sharing options...
yandoo Posted June 30, 2008 Author Share Posted June 30, 2008 yes thats right, how can i over come this please?? Link to comment https://forums.phpfreaks.com/topic/112508-how-to-insert-multiple-records-of-same-table/#findComment-577779 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.