By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,905 Members | 1,646 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,905 IT Pros & Developers. It's quick & easy.

row-level locking with Pear Database & MySQL

P: n/a
OK, anyone have some advice on implementing the likes of SELECT ... FOR

I'm trying to get it working in conjunction with the transaction
facilities built into Pear DB.

Obvious answer to obvious question: yes, I'm using InnoDB-formatted
tables within MySQL.

So far, all of the stuff I've put in place certainly isn't stopping me
from INSERTing, UPDAT[E]ing, but it doesn't seem to be locking the rows

I've created a transaction class with all of the nice autoExecute() and
executeMultiple() methods to make things ultra easy. Which,
incidentally, are all working fine.

So, for example: I open up record ID: 15 in browser A and the same
record in another browser B.

I can then make changes in browser B before COMMIT[t]ing my changes in
browser A.

Obviously, this isn't supposed to happen.

Any help would be great...
wayne smallman ][ octane interactive

Jul 20 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.