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() {
