function 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 = ''; for($page = 1; $page <= $maxPage; $page++) { if ($page == $pageNum) { $nav .= "( $page )"; } else { $nav .= " $page "; } } if ($pageNum > 1) { $page = $pageNum - 1; $prev = " <    "; $first = " <<    "; } else { $prev = "<    "; $first = "<<    "; } if ($pageNum < $maxPage) { $page = $pageNum + 1; $next = "     > "; $last = "     >> "; } else { $next = "    >"; $last = "    >>"; } echo "
"; echo $first . $prev . $nav . $next . $last; echo "
"; }