SETP:
1. Click the “archived now” link if the submission is ready for publication i.e all reviews/corrections effected (it will not be visible to the public yet).
2. Go to the "ARCHIVED SUBMISSIONS link" to publish them to their respective volume before it can be visible to the public.

$title"; }else{ $title_msg="Untitled"; } $authors=""; $all_authors=""; $sql_done = "SELECT * FROM authors_record WHERE submission_id = '$submission_id' ORDER BY id DESC"; $result9 = mysqli_query($conn, $sql_done) or die(mysqli_error($conn)); if (mysqli_num_rows($result9) > 0) { while($info9 = mysqli_fetch_array($result9)) { $all_authors.=$info9['first_name'].", "; } $authors= rtrim($all_authors, ', '); } $sql_done = "SELECT * FROM review_comment WHERE submission_id = '$submission_id' AND status=''"; $result9 = mysqli_query($conn, $sql_done) or die(mysqli_error($conn)); $unapp_review = mysqli_num_rows($result9); $sql_done = "SELECT * FROM review_comment WHERE submission_id = '$submission_id' AND status='approved'"; $result9 = mysqli_query($conn, $sql_done) or die(mysqli_error($conn)); $app_review = mysqli_num_rows($result9); if($status=='completed'){ $status= "$status"; }elseif($status=='archived'){ $status= "$status"; }elseif($status=='published'){ $status= "$status"; } print " "; } print "

Id	Submitted Date	Section	Authors	Title	Status	File Updates	Review Status	Publish
00$submission_id	$date_time	$jounal_section	$authors	$title_msg	$status	0 File Updates	$unapp_review Unapproved | $app_review Approved	archived now

"; // how many rows we have in database $result = mysqli_query($conn, $query) or die(mysqli_error($conn)); $numrows = mysqli_num_rows($result); // how many pages we have when using paging? $maxPage = ceil($numrows/$rowsPerPage); $self = $_SERVER['PHP_SELF']; // creating 'previous' and 'next' link // plus 'first page' and 'last page' link // print 'previous' link only if we're not // on page one if ($pageNum > 1) { $page = $pageNum - 1; $prev = " [Prev] "; $first = " [First Page] "; } else { $prev = ' [Prev] '; // we're on page one, don't enable 'previous' link $first = ' [First Page] '; // nor 'first page' link } // print 'next' link only if we're not // on the last page if ($pageNum < $maxPage) { $page = $pageNum + 1; $next = " [Next] "; $last = " [Last Page] "; } else { $next = ' [Next] '; // we're on the last page, don't enable 'next' link $last = ' [Last Page] '; // nor 'last page' link } // print the page navigation link echo $first . $prev . " Showing page $pageNum of $maxPage pages " . $next . $last; if ($maxPage == 0) { print "

SORRY No record found"; } ?>