my %hash;
my %rec;
my $sth = $db->prepare ("select * from tablename");
$sth->execute;
$sth->bind_columns (\@hash{@{$sth->{NAME_lc}}});
while ($sth->fetch) {
    $hash{$rec{week}} = [ $rec{month}, $rec{workperiod} ];
    }