Jump to content


Photo

Locking a record


  • Please log in to reply
2 replies to this topic

#1 piznac

piznac
  • Members
  • PipPipPip
  • Advanced Member
  • 261 posts

Posted 27 October 2005 - 06:18 PM

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

#2 jamiemcconnell

jamiemcconnell
  • Members
  • Pip
  • Newbie
  • 7 posts
  • LocationUnited Kingdom

Posted 28 October 2005 - 03:02 PM

Hi there,

It is possible to lock an entire table through a MySQL query

this page best explains it
http://dev.mysql.com...ock-tables.html

Just dont forget to unlock it again!
// Jamie!

#3 piznac

piznac
  • Members
  • PipPipPip
  • Advanced Member
  • 261 posts

Posted 28 October 2005 - 03:42 PM

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?






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users