Help needed for table lock

john47832 wrote: »

Can anyone have a look at my code and tell me why I receive error message whilet attempting to lock a table

code works fine without table lock code

 
<? session_start(); 
include ("doDbase.php");
 $dbHost = "localhost";                                    // database variables: host location
 $dbUser = "root";           // database variables: username to access database
 $dbPass = "welcome1";          // // database variables: password for username above - should encrypt
 $dbDatabase = "library";          // database variables: database name
 
 $db = mysql_connect("$dbHost", "$dbUser", "$dbPass") or die ("Error connecting to database.");  // variable to connect to database
 
 mysql_select_db("$dbDatabase", $db) or die ("couldnt select the database.");  
 
  $pql = "LOCK TABLES item READ";
 if (!mysql_query($pql)){
  die('Error: ' . mysql_error());
 }
 
  $sql="SELECT first_name, last_name, address1 from person";
 
  $result = mysql_query($sql);
 
  echo "<table border='1'>
<tr>
<th>FirstName</th>
<th>LastName</th>
<th>Address</th>
</tr>";
 
  while($row = mysql_fetch_array($result)){
   echo "<tr>";
  echo "<td>" . $row['first_name'] . "</td>";
  echo "<td>" . $row['last_name'] . "</td>";
  echo "<td>" . $row['address1'] . "</td>";
  echo "</tr>";
  }
 
 $pql = "UNLOCK TABLES";
   if (!mysql_query($pql)){
  die('Error: ' . mysql_error());
 }
 
  ?>