my $user_id = 12; my $user = get_hash("SELECT * FROM users WHERE user_id = ?", $user_id); sub get_hash{ my ($statement, @param) = @_; my $sth = $dbh->prepare($statement); $sth->execute(@param) or die failLog( $dbh->errstr ); if(my $zeile = $sth->fetchrow_hashref()){ $sth->finish; return $zeile; } return 0; }