I'm not sure why you just couldn't add a boolean field to the table called "locked". Add a script in your php code to change this to true when a ticket is opened and move it to false after it is updated. You could even carry the userid to another feild and display who has the record currently locked.
Am I thinking too simplistic here?
__________________
But I don't want ANY Spam!
|