while (@row = $sth->fetchrow_array) { 

# Handle null or "undef's"
$employee_number                = (defined $row[0]) ? $row[0] : '';
$first_name                     = (defined $row[1]) ? $row[1] : '';
$last_name                      = (defined $row[2]) ? $row[2] : '';
$email                          = (defined $row[3]) ? $row[3] : '';

if ($#row > 0) {
print "HERE IS ALL YOUR DATA\n";
} else {
print "NO DATA FOR RECECORD SEARCHED. DO you WANT TO ADD NEW DATA\n";
}


}