Does anyone know anything about MySQL record locking. I am trying to develop a PHP application that searches the employees of a company and when a user has selected a record I don't want another person to be able to select that same record; therefore, preventing contradictory updates to a persons profile.
