rendered paste bodyfunction list_5_photos($server, $db_user, $db_pass, $database, $photo_table, $siteurl, $photo_dir, $thumb_dir) {
$rowsPerPage = 12;
$pageNum = 1;
if(isset($_GET['page'])) { $pageNum = $_GET['page']; }
$pageNum = strip_tags($pageNum);
$pageNum = htmlspecialchars($pageNum, ENT_QUOTES);
$pageNum = trim($pageNum);
$offset = ($pageNum - 1) * $rowsPerPage;
// Get photo file names and crap
connect($server, $db_user, $db_pass, $database);
$sql = "SELECT * FROM $photo_table ORDER BY id DESC LIMIT $offset, $rowsPerPage";
$result = mysql_query($sql) or die('Error, query failed @ 128!');
while($row = mysql_fetch_array($result)) {
$filename = $row['photo'];
$text = $row['text'];
$title = $row['title'];
}
// Get number of pages based on $rowsPerPage
$query = "SELECT COUNT(photo) AS numrows FROM $photo_table WHERE cat <> 'main'";
$result = mysql_query($query) or die('Error, query failed @115');
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];
$maxPage = ceil($numrows/$rowsPerPage);
$self = $_SERVER['PHP_SELF'];
$nav = '';
// Logic is there a previous and next page available
for($page = 1; $page <= $maxPage; $page++)
{ if ($page == $pageNum)
{ $nav .= "( $page )"; }
else
{ $nav .= "$page"; }
}
if ($pageNum > 1)
{ $page = $pageNum - 1;
$prev = " cant go back";
$first = " cant go all the way back"; }
else
{ $prev = "";
$first = "go back"; }
if ($pageNum < $maxPage)
{ $page = $pageNum + 1;
$next = " cant go forward ";
$last = " cant go all the way forward "; }
else
{ $next = "go forward";
$last = "go all the way forward"; }
// Print results
echo "<center><table CLASS=\"pages\" CELLSPACING=\"1\">
<tr>
<td CLASS=\"pages-links\">";
echo $first . $prev . $nav . $next . $last;
echo "</td></tr></table></center>";
}