How do I edit staff code in staff table?

Discussion in 'PHP' started by alimoses, Jan 21, 2011.

0
  1. #1
    I have table staff with columns id, code, surname, othernam es.
    I want to edit staff profile and save.
    The staff code is unique for all the staff.
    Note: I want to update the profile with old staff code or a new staff code that is not already in use by another staff.
     
    alimoses, Jan 21, 2011 IP
  2. Thorlax402

    Thorlax402 Member

    Messages:
    194
    Likes Received:
    2
    Best Answers:
    5
    Trophy Points:
    40
    #2
    I'm afraid you may have to clarify a little. I assume each row in the table is for a different staff member. I would also assume that each row "id" is unique. Is the "code" column another unique identifier? And am I right in saying that you are trying to generate a new unique "code" for a specific user?
     
    Thorlax402, Jan 21, 2011 IP