[keath]

Give us a hint. What was expected, what happened? Were there error messages?

I did notice that even though all results were fetched in this line:

my $employees = $sth->fetchall_arrayref({});

you attempted to fetch again:

while ( my @row = $sth->fetchrow_array( ) ) {
   print $csv->print($FILE, \@row);
}

If the first fetch is working (that's what Data::Dumper is for), then just use those results by looping over the array.

[Laurent_R]

From the DBI module documentation:

The fetchall_arrayref method can be used to fetch all the data to be returned from a prepared and executed statement handle. It returns a reference to an array that contains one reference per row.

Thus, when you do this:

my $employees = $sth->fetchall_arrayref({});

$employee is now a ref to an array containing references to all of your data rows.