prepare($sql1);
$stmt1->bind_param("diii", $Session_Hours, $Program_ID, $Group_ID, $Course_ID);
$stmt1->execute();
$affected1 = $stmt1->affected_rows;
$stmt1->close();
// Update Course_Group_Schedule_Main
$sql2 = "UPDATE Course_Group_Schedule_Main
SET Course_Hours = ?
WHERE Program_ID = ? AND Group_ID = ? AND Course_ID = ?";
$stmt2 = $mysqli->prepare($sql2);
$stmt2->bind_param("diii", $Session_Hours, $Program_ID, $Group_ID, $Course_ID);
$stmt2->execute();
$affected2 = $stmt2->affected_rows;
$stmt2->close();
/* // Optionally, update the master Courses table as well:
$sql3 = "UPDATE Courses SET Course_Time = ? WHERE Program_ID = ? AND Course_ID = ?";
$stmt3 = $mysqli->prepare($sql3);
$stmt3->bind_param("dii", $Session_Hours, $Program_ID, $Course_ID);
$stmt3->execute();
$affected3 = $stmt3->affected_rows;
$stmt3->close(); */
// Success message
if ($affected1 > 0 || $affected2 > 0 ) {
header('Location: updatecoursesessionhours.php?error=✅ Course hours updated successfully in all relevant tables!');
//echo '
';
} else {
header('Location: updatecoursesessionhours.php?error=No records were updated. Please check your selection.');
//echo '
No records were updated. Please check your selection.