prepare($query);
$stmt->bind_param("i", $Program_ID);
} else {
$query = "SELECT
MIN(s.Schedule_ID) AS Schedule_ID,
c.Course_Name,
g.Group_Name,
GROUP_CONCAT(DISTINCT s.Time_Slot ORDER BY s.Time_Slot SEPARATOR ', ') AS Time_Slot,
MIN(s.Start_Date) AS Start_Date,
MAX(s.End_Date) AS End_Date
FROM course_group_schedule_main s
JOIN Courses c ON s.Course_ID = c.Course_ID
JOIN manager_group_name g ON s.Group_ID = g.Group_ID
WHERE s.Assigned = 0
GROUP BY s.Course_ID, s.Group_ID
ORDER BY Start_Date ASC";
$stmt = $mysqli->prepare($query);
}
$stmt->execute();
$result = $stmt->get_result();
while ($row = $result->fetch_assoc()) {
echo "
| " . htmlspecialchars($row['Course_Name']) . " |
" . htmlspecialchars($row['Group_Name']) . " |
" . htmlspecialchars($row['Time_Slot']) . " |
" . htmlspecialchars($row['Start_Date']) . " |
" . htmlspecialchars($row['End_Date']) . " |