function getmankw($field, $text) { $text = mysql_real_escape_string($text); $cloud = mysql_query("SELECT title_orig, genre, notes, stat_id, man_id, per_id, datesubmitted FROM tbl_manuscript where {$field} LIKE '%{$text}%'") or die(mysql_error()); while ($arr = mysql_fetch_assoc($cloud)) { $perid = $arr['per_id']; $author = authname($perid); printf(' <p> <table> <tr><td>Manuscript ref #:</td><td><a href="viewmanuscript.php?manid=' . $arr['man_id'] . '">' . $arr['man_id'] . '</a></td><td></td></tr> <tr><td>Author:</td><td><a href="viewauthor.php?perid=' . $perid . '">' . $author . '</a></td><td></td></tr> <tr><td>Title:</td><td>' . $arr['title_orig'] . '</td><td></td></tr> <tr><td>Genre:</td><td>' . $arr['genre'] . '</td><td></td></tr> <tr><td>Notes:</td><td>' . $arr['notes'] . '</td><td></td></tr>'); getstatus($arr['stat_id']); printf('<tr><td>Date submitted: </td><td>' . $arr['datesubmitted'] . '</td><td></td></tr>'); getfileinfo($arr['man_id']); } }
die('There was an error running the query [' . $query->error . ']'); } $arr = $res->fetch_assoc(); $perid = $arr['per_id']; $author = authname($perid); printf(' <div class="manuscript"> <table> <tr><td>Manuscript ref #:</td><td>' . $manid . '</td><td></td></tr> <tr><td>Author:</td><td>' . $author . '</a></td><td></td></tr> <tr><td>Title:</td><td>' . $arr['title_orig'] . '</td><td></td></tr> <tr><td>Genre:</td><td>' . $arr['genre'] . '</td><td></td></tr> <tr><td>Author Note:</td><td>' . $arr['notes'] . '</td><td></td></tr>'); printf('<tr><td>Date submitted: </td><td>' . $arr['datesubmitted'] . '</td><td></td></tr>'); getfileinfo($manid); printf('</div>'); printf('<span class="manuside">'); if ($arr['active'] == 'Y') { printf('Active <br /><br />'); } else { printf('Inactive <br /><br />'); } getstatnohtml($arr['stat_id']); printf('</span>'); $perid = $_SESSION['per_id']; $query = "SELECT rev_id FROM tbl_review WHERE per_id={$perid} AND man_id={$manid}"; if (!($res = mysqlConnection::getConnection()->query($query))) { die('There was an error running the query [' . $query->error . ']'); } $rows = $res->num_rows;