}
} else {
while ($row12 = mysqli_fetch_array($r12)) {
if ($view == 'date') {
$opt_third_3_hh = '<option value="' . $row12['user_id'] . '">' . $row12['Name'] . ' ... ' . date('F j, Y', strtotime($row12['Last'])) . '</option>';
} else {
if ($view == 'alpha') {
$opt_third_3_hh .= '<option value="' . $row12['user_id'] . '">' . $row12['Name'] . '</option>';
}
}
}
}
if ($num_row_third_3 = 1) {
$opt_third_3_setting = '<option value="' . $row_third_3['setting_id'] . '" selected>' . $row_third_3['Setting'] . '</option>';
while ($row18 = mysqli_fetch_array($r18)) {
$opt_third_3_setting .= '<option value="' . $row18['setting_id'] . '">' . $row18['Setting'] . '</option>';
}
} else {
while ($row18 = mysqli_fetch_array($r18)) {
$opt_third_3_setting = '<option value="' . $row18['setting_id'] . '">' . $row18['Setting'] . '</option>';
}
}
week_nav($nav_href, $monday);
// Week to week navigation
include 'include/make_tms_slips.php';
include 'view/form_edit_tms.html';
week_nav($nav_href, $monday);
// Week to week navigation
include 'include/footer.html';
//Include the footer
}
$ptws_song_3 = $ptws_row['ptws_song_3'];
}
$cts_detail_query = "SELECT * FROM cts_detail WHERE week_of = '{$monday}'";
$cts_r = mysqli_query($dbc, $cts_detail_query) or die("MySQL error: " . mysqli_error($dbc) . "<hr>\ncts_query: {$cts_detail_query}");
while ($cts_row = mysqli_fetch_array($cts_r)) {
$song_1 = $cts_row['song_1'];
$cbs = $cts_row['cbs'];
$cbs_url = $cts_row['cbs_url'];
$bible_read = $cts_row['bible_read'];
$no_1 = $cts_row['no_1'];
$no_2 = $cts_row['no_2'];
$no_2_source = $cts_row['no_2_source'];
$no_2_url = $cts_row['no_2_url'];
$no_3 = $cts_row['no_3'];
$no_3_source = $cts_row['no_3_source'];
$no_3_url = $cts_row['no_3_url'];
$song_2 = $cts_row['song_2'];
$sm_1 = $cts_row['sm_1'];
$sm_2 = $cts_row['sm_2'];
$sm_3 = $cts_row['sm_3'];
$song_3 = $cts_row['song_3'];
}
require CLSMYSQL;
// Close the connection
include 'view/form_edit_details.html';
week_nav($nav_href, $monday, $prevw, $currw, $nextw);
// Week to week navigation
include 'include/footer.html';
//Include the footer
}
// End of form submission IF