I don't have time for a comprehensive answer right now, but I did want to say this: Please read and follow Use strict and warnings as well as Bobby Tables, your code is vulnerable to SQL injection! In regards to the latter, use placeholders instead.

Debugging aids: Basic debugging checklist, CGI Help Guide, Troubleshooting Perl CGI scripts, and use CGI::Carp qw/fatalsToBrowser/;