my $result_array = $sth->fetchall_arrayref;

if ($result_array) {
    print "success\n";
    if (@$result_array) {
        print "found rows @$result_array\n";
    }
    else {
        print "no rows returned\n";
    }
}
else {
    print "query failed!!\n";
}