piznac Posted October 27, 2005 Share Posted October 27, 2005 Hey guys, I have a form that updates a mysql db. I will have multiple user updating it. I need a script that will some how lock the form from user a when user b is using the form...I found a tutorial for this but it was in .asp --- of course in need this in .php --- any help would be great Using - Dreamweaver 8 mysql php Thanks Quote Link to comment Share on other sites More sharing options...
jamiemcconnell Posted October 28, 2005 Share Posted October 28, 2005 Hi there, It is possible to lock an entire table through a MySQL query this page best explains it http://dev.mysql.com/doc/refman/5.0/en/lock-tables.html Just dont forget to unlock it again! Quote Link to comment Share on other sites More sharing options...
piznac Posted October 28, 2005 Author Share Posted October 28, 2005 Jamie, Thanks for the help...one more question. This statement has me a bit confused = Normally, you do not need to lock tables, because all single UPDATE statements are atomic; no other thread can interfere with any other currently executing SQL statement. does this mean I should not worry about locking table, because it does it by itself? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.