my $query = $db->prepare("select code, username, userid from transactions"); $query->execute();