$statement = 'SELECT trnemailaddress, activedate FROM
     `customer-trans` WHERE (UNIX_TIMESTAMP(activedate)
      + ? ) < (UNIX_TIMESTAMP(NOW());';

$sth = $dbh->prepare($statement) or die "Couldn't prepare statement:".$dbh->errstr;
$sth->execute($grace) or die "Couldn't prepare statement:".$dbh->errstr;

# get and print results
while ($ref = $sth->fetchrow_hashref()){

    print $ref->{'trnemailaddress'} . "\t\t\t". $ref->{'activedate'};

}