confirm_query($result); } } $sel_subjects = array(); foreach ($sel_list as $list_id) { $query = "INSERT IGNORE INTO rel_list_study (`list_id`, `study_id`) VALUES ('" . $list_id . "', '" . $study_id . "')"; $result = mysql_query($query, $dbconnect); confirm_query($result); $subjects = get_active_subj_for_list($list_id); while ($row = mysql_fetch_array($subjects)) { if ($sel_template != null) { $template_body = get_template_body($sel_template, $lang); $subj_id = $row['subj_id']; $subj_name = $row['first_name'] . " " . $row['last_name']; $subj_email = $row['email']; $title = get_study_name($study_id, $lang); $rel_template = get_rel_template_id_for_study($study_id); if ($sel_template == $rel_template && $sel_template != null) { $query = "INSERT IGNORE INTO mails (`study_id`, `subj_id`, `nume`, `email`, `titlu`, `body`)\n\t\t\t\t\t\t\t\t\tVALUES ('" . $study_id . "', '" . $subj_id . "', '" . $subj_name . "', '" . $subj_email . "', '" . $title . "', '" . $template_body . "');"; } else { $query = "REPLACE INTO mails (`study_id`, `subj_id`, `nume`, `email`, `titlu`, `body`)\n\t\t\t\t\t\t\t\t\tVALUES ('" . $study_id . "', '" . $subj_id . "', '" . $subj_name . "', '" . $subj_email . "', '" . $title . "', '" . $template_body . "');"; } $result = mysql_query($query, $dbconnect); confirm_query($result); $sel_subjects[] = $subj_id; } } } $rel_list = get_sel_list_for_study($study_id); foreach ($rel_list as $tester) { if (!in_array((int) $tester, $sel_list)) {
<div id="wrapper"> <div id="main_content"> <p class="title">Prescriptive Index</p> <select id="study_id" name="study_id"> <?php $result = get_all_study_ids(); while ($row = mysql_fetch_array($result)) { ?> <option value="<?php echo $row['study_id']; ?> "><?php echo get_study_name($row['study_id'], 'ro'); ?> </option> <?php } ?> </select> <div id="list_details" style="margin-top:30px;"></div> </div> <script> $(document).ready(function() { $("#study_id").change(function() {