Crate an Array, where the Key is the ItemId, and the value is the ItemQty.
If the client want to delete an the item, unset the key, if the client
wont to add or remove an item quantity, just change the value.
Then when the items and quantities are correct, just
If (! (INSERT . (order, ItemI
t;[EMAIL PROTECTED]>
Date: May 20, 2005 4:45:05 PM PDT
To: "'Miguel Guirao'" <[EMAIL PROTECTED]>, [EMAIL PROTECTED]>
Subject: RE: [PHP-DB] multiple queries, one transaction - REWORDED
I have a scenario where I have multiple inserts into a table and
need to
know
I have a scenario where I have multiple inserts into a table and need to
know that ALL inserts were successful and if not that there were no
inserts.
I've seen an article on transactions in php/mysql and have a few
questions.
I have a table with orderID, itemIDs and itemQty
Someone with an order