Select Code to Download

-----------------------------------------------------
|MemberId|ADPID|PayoutAmount|status|statuschanged|t
...
-----------------------------------------------------
|8 |101 |603.98 |Preissued|1206583466|2008-03-26 13:34:48
-----------------------------------------------------

File #, Amount, Check Number, Pay Date
101, 2218.20, 10108, 03/26/2008

File #, Amount, Check Number, Pay Date
101, 1313.86, 10108, 03/26/2008

# Wrote right now, not a copy and paste, so not exact...
open(FILE, "/path/to/apd/file.csv") or die "could not open file: $!";
...
 }
 $sth->finish();
}

$sth = $dbh->prepare(qq{ select * from payouts where SUM(amount) = ?})
+;
$sth->execute($_fileparts[2]);