hi! i'm running mysql-max version 3.23.52-max on a windows xp machine with
the apache web server. i'm trying to get innodb transactions to work using
a php application.
here is the transaction i am trying to run:
set autocommit=0;
begin work;
select * from .... for update;
update ...;
commit;
to check if the above code is working, i open 2 clients, one client will
try accessing the locked record after the select statement has been
executed by the other.
if i execute the test in the database console itself, record locking
works. but when i execute the transaction via php commands, no record
locking is evident, but the select and update statement gets executed and
no error messages are generated from the database. i need to get the
record locked.
any help on this matter will be greatly appreciated! thanks!
liza ortega
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php