$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, ', '); } print " "; } print "

Id	Submitted Date	Section	Authors	Title	Status
00$submission_id	$date_time	$jounal_section	$authors	$title_msg	Incomplete	Delete

"; // 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"; } ?>