Question : LOCK querie

[Arsenik]

When and How am i supposed to LOCK a table?

Like this?

$DB_site->query("LOCK TABLE my_table");

some code here

$DB_site->query("UNLOCK TABLE");

Is this the way to go about it? :surprised:

[Dean C]

Well the syntax is correct. Not sure about the LOCK and UNLOCK mysql commands though. Never cames accross them

- miSt

[Bitsys]

<a href="http://www.mysql.com/doc/en/LOCK_TABLES.html" target="_blank">http://www.mysql.com/doc/en/LOCK_TABLES.html</a> has some useful info.

However, I've never used those commands before, so I don't know anything about when you use them.