I have a MYSQL database that I can add records to via a form. I am unsure as to how to set up editing permissions for specific records utilizing some kind of password scheme. I assume that I should be using a unique field value that is known by the user. My first thought is that a person would search for an existing record and then click on an edit link to modify it. I can probably figure this part out.
Can someone give me some ideas as to how to set up a simple validation for adding new records and/or editing existing records?