Re: [PHP] Commit/Roll Back Transaction in PHP/mySQL

2002-07-09 Thread Peter J. Schoenster
On 9 Jul 2002 at 22:07, Thomas Edison Jr. wrote: > why the transaction is interrupted, i would like the > transaction to roll back.. that is, all the records > entered before the interruption SHOULD NOT remain in > the database, they should get deleted or something, so > that the transaction can

Re: [PHP] Commit/Roll Back Transaction in PHP/mySQL

2002-07-09 Thread Justin French
What about uploading the new data to a temporary table... once you're assured that every thing was completed, you can delete the old and rename the new to suit... Simular thing could be done with copying the existing table, etc. Justin French on 10/07/02 3:07 PM, Thomas Edison Jr. ([EMAIL PR

[PHP] Commit/Roll Back Transaction in PHP/mySQL

2002-07-09 Thread Thomas Edison Jr.
Glory! Im creating a .php file that will be uploading & putting in data from a .csv file into mySQL Tables on the server. However, my problem is that if there is any kind of a problem during the transaction, i.e, system shut down, electricity problem, or any reason why the transaction is interrup