Re: [PHP-DB] multiple queries, one transaction - REWORDED

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=20
<start transaction>
<begin foreach>
If (! (INSERT ..... (order, ItemID (the array key), ItemQty (the array
value of the key))...))
<rollback transaction>
<break>
<end foreach>
<commit transaction>

So if the insert is failed, you rollbackit.
No need for a DELETE

--=20
Atte, Andr=E9s G. Monta=F1ez
T=E9cnico en Redes y Telecomunicaciones
Montevideo - Uruguay