Re: PHP transaction issue ( using 'for update')

[Mark Procter]

Thanks for the reply Georg, that IS useful to know. I'd understand if it did roll back when the page is transfered but it doesn't, it commits!?

The issue that i'm most concerned about is the fact that other users can still access the data that is so say 'locked' for update. I tested to see whether there is a transaction issue with my setup, using a couple of command line connections to the database, and safe to say it did work in the sense that the first (" select ....for update") connection saw the data while the second just hung until i commited the first.

So why doesn't this work via the PHP code?? I used the same query as I posted originally (with a substituted value for '$animal_id') in the command line test so everything is the same!?

Any more help would be greatly appreciated.