Locking Rows

[Anon]

Is it possible in MYSQL to ROW LOCK in a table, so two people can't access or change the same information in a row at the same time.

So If i access a row and it is already being accessed a message will pop-up saying PlEASE WAIT or something.

Thanks

[Anon]

You must be using a table type of InnoDB to do row-level locking.