$sth = $dbh->prepare( " SELECT date,name,status FROM requests WHERE date >= '$date' ORDER BY date " ); $sth->execute(); my $reqs; push @{$reqs}, $_ while $_ = $sth->fetchrow_hashref();