simple_pagination.php

<?php
	$rec_limit = 20;

	$sql = $con_cdr->prepare($query_count);

	$sql->execute();

	$rec_count = $sql->fetch(PDO::FETCH_ASSOC);
	$rec_count = $rec_count['count'];

	if($page != 0)
	{
		$offset = $rec_limit * $page;
	}
	else
	{
		$offset = 0;
	}

	$left_rec = $rec_count - ((int)$page * (int)$rec_limit);

	$query_new = $query_select . "LIMIT $offset, $rec_limit";