foreach (@zuloeschende_box_ids) { my $sth_check = $dbh->prepare("SELECT sort_id FROM $config{'db_prefix'}navibox WHERE box_id=?") or die $dbh->errstr; $sth_check->execute($_) or die $dbh->errstr; my $aktuelle_sort_id = $sth_check->fetchrow_hashref(); $sth_check->finish(); my $sth_box = $dbh->prepare("DELETE FROM $config{'db_prefix'}navibox WHERE box_id=?") or die $dbh->errstr; $sth_box->execute($_) or die $dbh->errstr; $sth_box->finish(); my $sth_check = $dbh->prepare("UPDATE $config{'db_prefix'}navibox SET sort_id = sort_id -1 WHERE sort_id > ?") or die $dbh->errstr; $sth_check->execute($aktuelle_sort_id->{sort_id}) or die $dbh->errstr; $sth_check->finish(); }