Not locking....

[Arend Jan Zwart]

I have the following PHP code... the second SQL statement should not be executed...

There are 3 records in this DB, al have set 'menu'at page..

i run this SQL statement...

$resource = mysql_query("START TRANSACTION;") or die (mysql_error());
$resource = mysql_query("SELECT * FROM `data` LIMIT 3 FOR UPDATE;") or die (mysql_error());

I display the result, bit never close the transaction.
The i start this new one... and strangly enough it works. But the rows should still be locked because of statement one ??

$resource1 = mysql_query("START TRANSACTION;") or die (mysql_error());
$resource1 = mysql_query("SELECT * FROM `data` WHERE `page` = 'menu' LIMIT 3 LOCK IN share mode;") or die (mysql_error());

Does anyone know's a solution ??