mysql lock tables

[Anon]

Hi!
Can anybody help me with LOCK TABLES?

After locking a table as "read", I cannot write to it. Is seems that I am taken as another thread and denied access.

When trying to insert, I get "Table was locked with a READ lock and can't be updated".
But it was me that locked it just before!

---

$query = "lock tables Hotels read";
$result = mysql_query($query);
if ($result == 0) {
print "CANNOT LOCK HOTELS";
}

$query = "insert into Hotels ...";
$result = mysql_query($query);
if ($result == 0) {
print "ERROR 2: ".mysql_error();
}

[[deleted]]

Ehm... you may want to read the mysql manual (again)

-- quote --
If a thread obtains a READ lock on a table, that thread (and all other threads) can only read from the table. If a thread obtains a WRITE lock on a table, then only the
thread holding the lock can READ from or WRITE to the table. Other threads are blocked.

-- end quote --