lock tables problem
| From: | Mark Lo | Date: | Tue, 08 Aug 2000 19:19:12 +0000 |
| Subject: | lock tables problem | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-10758@lists.php.net to get a copy of this message | ||
Hi,
my script is as follows (once I lock the table1, i won't be able to read table2)
what is the problems;
require("Password.hlh");
mysql_select_db("database1");
mysql_query("lock tables table1 read");
$query="select * from table1";
then---the problem starts here...
require("Password.hlh");
mysql_select_db("database1");
mysql_query("lock tables table2 read");
$query="select * from table2";
---unable to select from table2---
Can anyone please point me out the problems.
Thank you so much
Mark