i have some problems with pages.. I use this code(something its wrong) Image - this is what i have now When i press for next page(31) show me „page not exists”
if(!isset($_REQUEST['page']) || empty($_REQUEST['page'])) {
$_REQUEST['page'] = 1;
}
$page = ceil($_REQUEST['page']);
$limit = 14;
$start = $limit;
$end = $page*$limit-($limit);
$query = CSA::getInstance()->sqli->query("SELECT COUNT(*) as `players` FROM `played_time`;");
if($query->num_rows > 0) {
$getlist = $query->fetch_assoc();
}
$pages = ceil($getlist['players']/$limit);
$previous = ($page - 1 <= 0) ? "<li class='disabled'><a href='#'>« Prev</a></li>" : "<li><a href=\"./categories-".CSA::getInstance()->sqli->real_escape_string($_GET['id'])."-".($page-1)."\">« Prev</a></li>";
$nextpage = ($page + 1 > $pages) ? "<li class='disabled'><a href='#'>Next »</a></li>" : "<li><a href=\"./categories-".CSA::getInstance()->sqli->real_escape_string($_GET['id'])."-".($page + 1)."\">Next »</a></li>";
echo $previous;
for($i=1;$i<=$pages;$i++) {
$href = ($page == $i) ? "<li><a href='#'>".$i."</a></li>" : "<li class='active'><a href=\"./categories-".CSA::getInstance()->sqli->real_escape_string($_GET['id'])."-".$i."\">".$i."</a></li>";
echo $href;
}
echo $nextpage;
echo "</ul>
</div>";