my $sql = "SELECT ID, Name, Vorname, GebDatum, Klasse FROM User WHERE Status != 'X' ORDER BY $order;"; my $sth = $dbh->prepare($sql); $sth->execute; my @daten = (); while ( my @row = $sth->fetchrow_array ) { push @daten, join( ";" , @row ); }