"; }else{ $show_img ='No Picture'; } include('inc_type.php'); $cat_id=$item_category; include('inc_cat.php'); include('inc_user.php'); if($what_for==2){ $item_value="$item_value Naira"; } print " "; } print "

Id	List type	Value	Category	Item name	Details	Added by	Location	Picture	Date Added	Date Edited	Status	Option
$item_id	$list_type	$item_value	$cat_name	$item_name	$item_detail	$full_name	$owner_location	$show_img	$date_uploaded	$date_modify	$status	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"; } ?>