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 Link to comment https://forums.phpfreaks.com/topic/2746-locking-a-record/ 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! Link to comment https://forums.phpfreaks.com/topic/2746-locking-a-record/#findComment-9217 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? Link to comment https://forums.phpfreaks.com/topic/2746-locking-a-record/#findComment-9218 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.