my $check_q = "SELECT COUNT(EMPLOYEE_NUMBER) FROM EMPLOYEE WHERE EMPLOYEE_NUMBER = ?";
my ($employee_already_present) = $dbh->selectrow_array($check_q, undef, $employee_number);

if ($employee_already_present)
{
  # raise an HTML error
}
else
{ 
  # continue with the insert statement
}