I've never used a lock on a MySQL table so far, but need one now. Two questions:
1. Do I set the lock by a normal query, but in the form of "LOCK TABLE <tablename> WRITE", instead of "SELECT * FROM <tablename> WHERE x = 1"?
2. Can I set the lock in one query, then perform multiple other queries on the table, in between which I do some PHP work, and then release the lock several queries and lines of PHP code later?
-- anders thoresson
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php