my @transactions;

                my $sth = $db_h->Query("
                SELECT serial_num, FROM_UNIXTIME(trans_date) AS 'Action_date', actor, type, trans_data, content FROM transtable
                ORDER BY serial_num;
                 ");

    $sth->execute();


         while( my $trans_hash = $sth->fetchrow_hashref("NAME_lc") )
        {
                 push (@transactions,$trans_hash);

        }

  return @transactions;