Locks in a InnoDB table

[Yogesh Mahadnac]

Hi!

I have a question for you.
The thing is, I don't understand how to release the lock after the transaction is completed.

For example, 1 user calls a particular reservation number for update (e.g. reserNo 1). He inputs the number in the text field provided.
Normally when this happens, I select * from reservation where resaNo = theNumberInput

Now assuming that a second user wants to view the details of the same reservation number. I don't want the second user to be able to make changes on that particular reservation until the 1st user has finished.

How do I proceed using InnoDB Locks?

Thanks and regards

Yogesh Mahadnac