Hi Poj,
As you must have guessed what I am trying to do here is to create an employees edit form in which like the delete form which you created select an employee from the drop down box which should bring up the employee data in another form or whatever ready to be edited.
I know its too much to ask and I'm myself finding it hard to ask but if you can give me something like you did for the delete form that will be a life saver :).
All the fields are listed above, whenever you have time.
Many thanks
Rgds
Terry

Its complaining on $input and I don't know what to do, this format of script that I copied from Poj's style is much easier for you monks to review, I hope.
Many thank for your help in advance.
Rgds
Terry

which enabels strictures, see perldoc strict. You need to declare variables before using them, e.g. my $input;. Copying and pasting other peoples code without understanding it is a bad idea. Consider spending some time working your way through the following links:

Hi Poj,
I changed it to empid, but the behavior is still the same, still its not executing the update query, no updates are being sent to the database and even worse no errors are being displayed.
There's got to be something else.
Rgds
Terry

Hi Poj,
First of all thank you very very much for all your help. The problem finally got solved, I had also posted it on PERLGURU and a Guru there his name is Chris noticed a typo in our script, I was calling a wrong hash key at:

Hi Poj,
What happens now is when I press UPDATE it sends me back to the first screen to select an employee to be updated, its not updating anything, worse is that its not even sending update query to the database, can you PLEASE go over the script again to see where things are going wrong.
Here is the updated script :

"not working" isn't an error report. Consider reading and understanding How do I post a question effectively?. You load CGI but seem to be ignoring it!? If you are starting a new project using CGI, don't. It's very old and has lots of issues. Consider using a modern framework like Dancer. Get into the habbit of reading the documentation and example code provided.

Read the section on placeholders and bind variables from the DBI documentation. Never forget little Bobby Tables.

If you insist on loading (or actually using) CGI work your way through Ovid's CGI Course. You'll learn how to actually use the features provided by the module and how to debug problems.