Locking Needed

[barrypalmer]

PHP/mySQL website to allow multiple user editting records facility.

Each record has 'status' '0'=awaiting edit;'1'=being editted;'2'=done

PHP makes mySQL query

SELECT * FROM table WHERE status=0;

Then needs to quickly update status of this record to '1' to prevent someone else getting it.

Or should it be

UPDATE table WHERE status=0 set status=1;

But then how do I get the record data ?

Does it really need a LOCK table before the SELECT & UPDATE then UNLOCK table ?

[mwasif]

You can perform this operation in this sequence

1. LOCK table
2. SELECT a record from table
3. UPDATE the record (set status=0) using the Primary Key for the record you SELECTed in the previous step
4. UNLOCK table