'null', 'id' => 'null']; // $allAbt[] = ['name' => 'null', 'id' => 'null']; $stmt = $mysqli->prepare("SELECT t.id, t.name, t.vorname, t.programm, t.verein, GROUP_CONCAT(a.name SEPARATOR ', ') AS abteilung, GROUP_CONCAT(g.name SEPARATOR ', ') AS geraet FROM $tableTurnerinnen t LEFT JOIN $tableTurnerinnenAbt ta ON ta.turnerin_id = t.id LEFT JOIN $tableAbt a ON a.id = ta.abteilung_id LEFT JOIN $tableGeraete g ON g.id = ta.geraet_id GROUP BY t.id ORDER BY t.id DESC; "); $stmt->execute(); $result = $stmt->get_result(); $allTurnerinnen = $result->fetch_all(MYSQLI_ASSOC); $grouped = []; foreach ($allTurnerinnen as $entry) { if ($entry['abteilung'] == '') { $grouped['null']['null'][] = $entry; } else { $grouped[$entry['abteilung']][$entry['geraet']][] = $entry; } } $noAbt = $grouped; foreach ($allAbt as $abt) { $abtName = $abt['name']; foreach ($allGeraete as $geraet) { $geraetName = $geraet['name']; $noAbt[$abtName][$geraetName] = []; } } ?> Riegeneinteilung
'; echo ''; echo ''; foreach ($arrayRest as $entry) { echo ''; } echo ''; echo '
Keine Valide Abt (' . $count . ')
' . htmlspecialchars( $entry['vorname'] . ' ' . $entry['name'] . ' - ' . $entry['programm'] . ' - ' . $entry['verein'] ) . '
'; ?>

Riegeneinteilungspanel

'; echo '

Abteilung ' . htmlspecialchars($abtName) . '

'; echo '
'; foreach ($allGeraete as $geraet) { $geraetName = $geraet['name']; // Safely resolve entries $entries = $grouped[$abtName][$geraetName] ?? []; $count = count($entries); echo ''; echo ''; echo ''; foreach ($entries as $entry) { echo ''; } $grouped[$abtName][$geraetName] = []; echo ''; echo '
Gerät: ' . htmlspecialchars($geraetName) . ' (' . $count . ')
' . htmlspecialchars($entry['verein']) . ',
' . htmlspecialchars($entry['vorname']) . ' ' . htmlspecialchars($entry['name']) . ', ' . htmlspecialchars($entry['programm']) . '
'; } echo '
'; } ?>