PHP code for pagination.

pagination.php

<?php

$page  = $_GET['page'];
$limit = 12;

if(!is_numeric($page)) {
  $page = 1;
}

$end    = $limit * $page;
$offset = ($end - ($limit - 1));

$results = "SELECT * FROM `photos` WHERE `albumid` = '14' LIMIT $offset, $end";
$total   = "SELECT COUNT(*) FROM `photos` WHERE `albumid` = '14' AND `photoid` > $end";

// For pagination, this is how you'd determine whether to show next/prev buttons
if($page > 1) {
  // show the prev button
}

if($total > 0) {
  // show the next button
}