I want to update a record in a table depending on the value entered in the php form text field.
This isn't beyond what a tutorial can show you, so give that a google. As you haven't supplied us with a table structure, output code or any examples, we can't help you very much.
this will not give any idea what you want to do...
table structure and form is required.