prepare($queryProgram);
if (!$stmtProgram) {
die("Error preparing program query: " . $mysqli->error);
}
$stmtProgram->bind_param("i", $Program_ID);
$stmtProgram->execute();
$resultProgram = $stmtProgram->get_result();
if ($resultProgram->num_rows > 0) {
$rowProgram = $resultProgram->fetch_assoc();
$Program_Name = $rowProgram['Program_Name'];
} else {
$Program_Name = "Unknown Program";
}
$stmtProgram->close();
// Query to select groups from Manager_Group_Name that have no assignments in Course_Group_Schedule.
$query = "SELECT g.Group_ID, g.Group_Name
FROM Manager_Group_Name g
LEFT JOIN Course_Group_Schedule_Main s ON g.Group_ID = s.Group_ID AND s.Program_ID = ?
WHERE g.Program_ID = ? AND s.Schedule_ID IS NULL
ORDER BY g.Group_Name ASC";
$stmt = $mysqli->prepare($query);
if (!$stmt) {
die("Error preparing group query: " . $mysqli->error);
}
$stmt->bind_param("ii", $Program_ID, $Program_ID);
$stmt->execute();
$result = $stmt->get_result();
//echo "