Lidt problemer med pagination

<?php
	// Settings
	// int: Number of items on page
	$pageLength = 50;
	$currentPage = $_GET["underside"];
	
	// Capture items in database
	$totalNumberOfPosts = mysql_result(mysql_query("SELECT COUNT(id) AS total FROM $news_tabel"),0);
	
	$currentPage = (int)$_GET['underside'];
	$numberOfPages = ceil($totalNumberOfPosts/$pageLength);
	
	// Generating links
	$links = array();
	$links[] = $currentPage - 1 > 0 ? "<a href=\\"/archives/".($currentPage - 1)."\\"><< Previous</a>" : '<< Previous';
	for ($i=0;$i<$numberOfPages;$i++) {
		// if current page == counter, add [].
		$links[] = $currentPage == $i ? '<a href="/archives/'.$i.'">['.$i.']</a>' : '<a href="/archives/'.$i.'">'.$i.'</a>';
	}
	$links[] = $currentPage + 1 < $numberOfPages ? "<a href=\\"/archives/".($currentPage + 1)."\\">Next >></a>" : 'Next >>';
	echo implode(' ',$links);
?>

Det er så'n den gerne skulle fungere. Har bare rettet lidt til, efter det du har beskrevet.

Dette skulle meget gerne virke:

<?php
	// Settings
	// int: Number of items on page
	$pageLength = 30;
	
	
	// Capture items in database
	$sql2 = mysql_query("SELECT COUNT(id) AS total FROM $news_tabel");
	$rows2 = mysql_result($sql2,0);

	$numberOfPages = ceil($rows2/$pageLength);
	$currentPage = (int)$_GET['p'];
	
	// Generating links
	$links = array();
	for ($i=0;$i<$numberOfPages;$i++) {
		// if current page == counter, add [].
		$links = $currentPage == $i ? '<a href="/archives?p='.$i.'">['.$i.']</a>' : '<a href="/archives?p='.$i.'">'.$i.'</a>';
	}
	echo  implode(' ',$links);
?>

Jeg får bare:

Warning: implode() [function.implode]: Bad arguments. in /var/www/dumpen.dk/public_html/content/archives.php on line 64

Hvor linje 64 er echo implode(' ',$links);

På linjen:

$links = $currentPage == $i ? '<a href="/archives?p='.$i.'">['.$i.']</a>' : '<a href="/archives?p='.$i.'">'.$i.'</a>';

Skal der stå:

$links[] = $currentPage == $i ? '<a href="/archives?p='.$i.'">['.$i.']</a>' : '<a href="/archives?p='.$i.'">'.$i.'</a>';

Såvidt jeg lige kan se

Ja det hjalp.

Men hvis i trykker på de to links i første tråd, så er det gået lidt galt for min next og previous funktion.

Da de tæller 3-6-9-12-15-18-21 og min nummer [1] ting tæller 1-2-3-4-5-6-7-8-9 så passer de ikke helt sammen.

Jeg bruger lige pt dette script, men virker ikke som jeg vil have det :o

/* If previous number is higher then 0 */
if ($prev_num > 0) {
/* Creating a previous link */
echo "<a href=\\"/archives/". ($_GET["underside"]-$per_page) ."\\"><< Previous</a>";
}

echo " ";

// Settings
// int: Number of items on page
$pageLength = $per_page;


// Capture items in database
$sql2 = mysql_query("SELECT COUNT(id) AS total FROM $news_tabel");
$rows2 = mysql_result($sql2,0);

$currentPage = (int)$_GET['underside'];
$numberOfPages = ceil($rows2/$pageLength);

// Generating links
$links = array();
for ($i=0;$i<$numberOfPages;$i++) {
// if current page == counter, add [].
$links[] = $currentPage == $i ? '<a href="/archives/'.$i.'">['.$i.']</a>' : '<a href="/archives/'.$i.'">'.$i.'</a>';
}
echo implode(' ',$links);

echo " ";

/* If next number is higher then 0 */
if ($next_num > 0) {
echo "<a href=\\"/archives/". ($_GET["underside"]+$per_page) ."\\">Next >></a>";
}

Så vidt jeg kan se skal du vel også bare sige +- 1 og ikke +- $per_page?

Derudover skal du tjekker om $next_num er mindre end $numberOfPages - der hvor det link indsættes. Ellers vil den altid være der, så vidt jeg kan se

Nej så vælger den nemlig ikke indlæggene/blog entrys ud korrekt.

Gnu, det er meget fint script.
Men jeg kan ikke få den til vise rigtigt med information.

Førstee side er der 5 på næste side er der 8

<?php
	// Settings
	// int: Number of items on page
	$pageLength = 1;
	// Checks that pid is set else 1
	if (isset($_GET['pid'])) $currentPage = (int) $_GET['pid'];
	else $currentPage = 1;
	
	// Capture items in database
	$totalNumberOfPosts = mysql_result(mysql_query("SELECT COUNT(id) AS total FROM $news_tabel"),0);
	
	$limitNumberOfPosts = $currentPage * $pageLength;
	$startNumberOfPosts = $limitNumberOfPosts - $pageLength;
	$numberOfPages = ceil($totalNumberOfPosts/$pageLength);
	
	// Generating links
	$links = array();
	$links[] = $currentPage - 1 > 0 ? "<a href=\\"/archives/".($currentPage - 1)."\\"><< Previous</a>" : '<< Previous';
	for ($i=1;$i<=$numberOfPages;$i++) {
		// if current page == counter, add [].
		$links[] = $currentPage == $i ? '<a href="/archives/'.$i.'">['.$i.']</a>' : '<a href="/archives/'.$i.'">'.$i.'</a>';
	}
	$links[] = $currentPage + 1 < $numberOfPages ? "<a href=\\"/archives/".($currentPage + 1)."\\">Next >></a>" : 'Next >>';

mysql_query("SELECT *,DATE_FORMAT(`date`, '%d %m %Y') AS `date`,DATE_FORMAT(`date`, '%H:%i') AS `time` FROM `blog` WHERE `hide`=0 ORDER BY `id` DESC LIMIT $startNumberOfPosts,limitNumberOfPosts");
echo "info";
echo implode(' ',$links);
?>

Det er simpelthen fordi din sql er forkert...

der skal stå "...LIMIT [start], [antal]" og IKKE "...LIMIT [start],[slut]"

Dvs.:

$limitNumberOfPosts = $pageLength;
$startNumberOfPosts = $currentPage * $pageLength;

Jeg kan ikke få skidtet til at virke

Jeg har prøvet og prøvet

Her er hele min kode (I kan også se den her: http://pastebin.ca/548566 hvor der er highlighting på)

<?php

/* Setting the page limit */
$per_page = $news_limit;

/* If underside is empty */
if (empty($_GET["underside"])) {
/* Then site will be 0 */
$site = 0;
}
else {
/* Else site will be $_GET["underside"] */
$site = $_GET["underside"];
}

/* Selecting id from $news_table (nyheder) where limit is $site + $per_page ($news_limit) */
$query = mysql_query("SELECT id FROM $news_tabel LIMIT ". ($site + $per_page) .",$per_page") or die(mysql_error());

/* Gathering the number of rows in the mysql query ($query) above */
$next_num = mysql_num_rows($query);

/* If $site-$per_page is higher or equal to 0 */

if (($site-$per_page) >= 0) {
/* Creating a new mysql query */
$query = mysql_query("select id from $news_tabel limit ". ($site - $per_page) .",$per_page");
/* Gathering the number of rows in the mysql query ($query) above */
$prev_num = mysql_num_rows($query);
}
else {
$prev_num = 0;
}

/* Making a query that is used to display html */
$sql = mysql_query("select * from $news_tabel ORDER BY $news_order_by DESC LIMIT $site,$per_page") or die(mysql_error());

/* Making a div tag */
echo "<div class=\\"post\\">";

	// Settings
	// int: Number of items on page
	$pageLength = 3;
	$currentPage = $_GET["underside"];
	
	// Capture items in database
	$totalNumberOfPosts = mysql_result(mysql_query("SELECT COUNT(id) AS total FROM $news_tabel"),0);
	
	$currentPage = (int)$_GET['underside'];
	$numberOfPages = ceil($totalNumberOfPosts/$pageLength);
	
	// Generating links
	$links = array();
	$links[] = $currentPage - 1 > 0 ? "<a href=\\"/archives/".($currentPage - 1)."\\"><< Previous</a>" : '<< Previous';
	for ($i=0;$i<$numberOfPages;$i++) {
		// if current page == counter, add [].
		$links[] = $currentPage == $i ? '<a href="/archives/'.$i.'">['.$i.']</a>' : '<a href="/archives/'.$i.'">'.$i.'</a>';
	}
	$links[] = $currentPage + 1 < $numberOfPages ? "<a href=\\"/archives/".($currentPage + 1)."\\">Next >></a>" : 'Next >>';
	echo implode(' ',$links);

/*Using the $sql to create the entrys and displaying it in html */
while ($row = mysql_fetch_array($sql)) { ?>
				<div class="header">
					<h3><?php echo $row["overskrift"]; ?></h3>
					<div class="date"><?php echo $row["dato"]; ?></div>
				</div>
				<div class="content">
				<p>
				
				<img src="<?php if ($row["blogimage"]) { echo "/$row[blogimage]"; } else { echo "/images/blogimages/na.JPG"; } ?>" class="floatleft" alt="Me" />
				
				<?php 
					/* Setting $content to $row["indhold"] */
					$content = $row["indhold"];
					
					/* Limiting the content to 240 signs with the php function www.php.net/substr */
					$content = substr($content,0,240);
					
					/* Setting three dots after the text */
					$content = "$content...";
					
					/* Stripping/adding stuff (like bbcode, smileys and more) to the content */
					$content = strip_text($content);
					
					/* Echoing content */
					echo "$content";

					/* Selecting comment number with mysql_query and mysql_num_rows */
					$comment_number = mysql_query("SELECT * FROM kommentar WHERE nyhedsid = $row[id]") or die(mysql_error());
				?></p>
				</div>			
				<div class="footer">
					<ul>
						<li class="comments"><a href="/blogentry/<?php echo $row["id"]; ?>/#comments" target="_blank">Comments (<?php echo mysql_num_rows($comment_number); ?>)</a></li>
						<li class="readmore"><a href="/blogentry/<?php echo $row["id"]; ?>/" target="_blank">Read more</a></li>
						<li class="views"><a href="/blogentry/<?php echo $row["id"]; ?>/" target="_blank">(<?php if (!$row["views"]) { echo "0"; } else { echo $row["views"]; } ?>) views</a></li>
						<li class="gototop"><a href="#top" title="Go to the top of the page">Top</a></li>
					</ul>
				</div>
			<?php
}

	// Settings
	// int: Number of items on page
	$pageLength = 3;
	$currentPage = $_GET["underside"];
	
	// Capture items in database
	$totalNumberOfPosts = mysql_result(mysql_query("SELECT COUNT(id) AS total FROM $news_tabel"),0);
	
	$currentPage = (int)$_GET['underside'];
	$numberOfPages = ceil($totalNumberOfPosts/$pageLength);
	
	// Generating links
	$links = array();
	$links[] = $currentPage - 1 > 0 ? "<a href=\\"/archives/".($currentPage - 1)."\\"><< Previous</a>" : '<< Previous';
	for ($i=0;$i<$numberOfPages;$i++) {
		// if current page == counter, add [].
		$links[] = $currentPage == $i ? '<a href="/archives/'.$i.'">['.$i.']</a>' : '<a href="/archives/'.$i.'">'.$i.'</a>';
	}
	$links[] = $currentPage + 1 < $numberOfPages ? "<a href=\\"/archives/".($currentPage + 1)."\\">Next >></a>" : 'Next >>';
	echo implode(' ',$links);

echo "</div>";

?>