Entry

How do I lock and unlock tables using PHP and MySQL?

Sep 25th, 2000 09:15
Narendra Jain, Gary Smith,

You Have to use the 'LOCK TABLE $tab_name' command to do this, as shown
below:
$db = mysql_connect("localhost", "myuser");
mysql_select_db("mydb", $db);
$tab_name = "employee";
$sql = "lock table $tab_name";
$result = mysql_query($sql);