I'm writing an app where I must insert a large number of rows into a mySQL
database individually. All the rows are related to each other, so I need to
ensure that integrity is maintained. In the event that one of the inserts
fails, I need to be able to roll back all the prior inserts. What is
If you have the standard table type installed
As you loop though though the arrays in PHP get ahold of the last ID
inserted via mysql_insert_id() and add it to an $inserted_array variable
and then at each insert check that the last insert was successful, and if
not send your db a bunch of
