Re: lock tables problem(corrections)
| From: | Mark Lo | Date: | Tue, 08 Aug 2000 19:25:48 +0000 |
| Subject: | Re: lock tables problem(corrections) | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-10760@lists.php.net to get a copy of this message | ||
----- Original Message -----
From: Mark Lo <markloky@netvigator.com>
To: php general <php-general@lists.php.net>; <mysql@lists.mysql.com>
Sent: Wednesday, August 09, 2000 3:19 AM
Subject: lock tables problem
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");
$query="select * from table2";
---unable to select from table2---
Can anyone please point me out the problems.
Thank you so much
Mark