A few ideas occur to me. You don't have enough information about
your schema for me to say for sure which of these would be best.
1 - put all the inserts into one statement:
$myQuery = INSERT INTO purchaseItems (orderID, itemIDs,
itemQty) VALUES (;
$i = 1;
foreach ($order as
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
start transaction
begin foreach
If
Any sort of abstraction library is going to be slower than directly using the
API.. I don't see how you can get around that.
-Micah
On Thursday 19 May 2005 07:01 am, Oriol wrote:
hi all,
I'm proud to install adodb library in my framework. I succesfully got it.
But, surprise! My scripts