function sendCommentEmail($dbc, $Message)
{
$r = mysqli_query($dbc, "Call spGetActiveEditors();");
complete_procedure($dbc);
$To = '';
while ($row = mysqli_fetch_array($r, MYSQLI_ASSOC)) {
$To = $To . $row["EmailAddress"] . ',';
}
$To = rtrim($To, ",");
//Remove the last comma from the string
$Subject = 'Comment from Journal of Critial Incidents website';
$Header = "From: NoReply@sfcrjci.org\r\nContent-Type: text/html;charset=iso-8859-1\r\nMIME-Version: 1.0\r\n";
mail($To, $Subject, $Message, $Header);
}
while($row = $years->fetch_assoc()) {
echo '<option value="'.$row["FileMetaDataID"].'"'.($row["Year"] == $years ? ' selected' : '').'>'.$row["Year"].'</option>';
}
*/
// }
?>
<div class="row flush">
<div class="side_nav col s2 guest_light">
<div class="guest">
<h3 class="title">Download Published Journals By Year</h3>
</div>
<ul>
<?php
// Storing value to variable in same line as query taken from jeff's register page
$years = mysqli_query($dbc, "Call spGetPublicationsYearsList();");
complete_procedure($dbc);
//Dispay the list of states
// echo '<option value="$years">Download a published journal</option>';
// This was taken from Jeff's Register page drop down boxes
while ($row = $years->fetch_assoc()) {
$ID = $row["FileMetaDataID"];
echo '<li class=""><a target=\\"_blank\\" href=\\"download.php?fid=' . $ID . '"><option value="' . $row["FileMetaDataID"] . '">' . $row["Year"] . '</a></li></option>';
}
?>
</ul>
<div class="guest">
<h3 class="title">Search</h3>
</div>
<form class="archivesearch"action="" method="post">
<input placeholder="Case Title" class="regular" type="text" name="case_title" size="15" maxlength="40" value="<?php
