Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New to the CF scene
    Join Date
    Aug 2010
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Help - Mysql row locking

    Good day everyone.

    I have no real knowledge of MySQL, i have a website that uses an open source php and mysql script.
    Its an genealogy script for dog pedigrees.

    I need your help, what i want to do exactly is run a Query that locks a row from not being edited until i physically unlock it.

    I only want users to view the dog pedigree, but not be able to edit or update it.
    any help would be appreciated .
    Thank you

  2. #2
    Super Moderator
    Join Date
    May 2005
    Location
    Southern tip of Silicon Valley
    Posts
    3,318
    Thanks
    2
    Thanked 230 Times in 223 Posts
    That's more of a php logic/coding issue than a mysql issue.

    You could add a boolean "readonly" field and only allow updates to that row based on the value of that readonly field.

  3. #3
    New to the CF scene
    Join Date
    Aug 2010
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanx allot.

    Will have to google it and see what comes up.


 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •