0

Hi all..

I'm trying to do a pagination using simple php script...

I set the maximum post to be displayed to be 5..

but my problem is, each post that being displayed,has skipped 1 post before it..
For example,let say that i got 5 post in total,instead of displaying post 1,2,3,4 and 5,
my page just display the post of 1,3 and 5 only(skip 1 post).

This is my real post database :

and this is what being displayed on my website page :

and this is my php code for the post :

<?php

    //max displayed per page
	$per_page = 5;
	
	//get started variable
	$start = $_GET['start'];
	
	//count records
	$record_count = mysql_num_rows(mysql_query("SELECT * FROM blogpost"));
	
	//count max pages
	$max_pages = $record_count / $per_page; //may come out as decimal

	if(!$start)
		$start = 0;
		
		//display data
		$get = mysql_query("SELECT * FROM blogpost ORDER BY id DESC LIMIT $start,$per_page");
		
		while($row = mysql_fetch_assoc($get))
			{
				//get data
				$r=mysql_fetch_assoc($get);
				$name=$r["name"];
				$comment=$r["comment"];
			
				echo "<div id='blogcontainer'>"."<img src='images/keyboard.png' height='100' width='100' />"."<div id='blogtitle'>".$row["title"]."</div>".
			"<br/>"."<div id='blogpost'>"."<div id='mainpost'>".$row["blogpost"]."</div>".""."<div id='date'>".$row["dp_datetime"]."</div>"."<br/>".
			"<a href='#' class='commenttoggle'>comment</a>".
			"<div class='togglebox'>".
			"<div class='commentbox'>".
			"<form method='POST' action='create_comment.php'>".
			"<input type='text' id='name' name='name' size='30'>Name<br/>".
			"<input type='text' id='email' name='email' size='30'>Email<br/>".
			"<input type='text' id='website' name='website' size='30'>Website <br/>".
			"<textarea rows='1' id='commentbox' name='comment' cols='40'></textarea><br/>".
			"<input type='submit' value='comment' id='commentboxsubmit'>".
			"</form>".
			"</div>".
			"</div>".	 
				"</div>"."</div>";
		 }
				
   
		//setup prev and next variables
		$prev = $start - $per_page;
		$next = $start + $per_page;
		
		//show prev button
		echo "<a href='index.php?start=$prev'>Prev</a>";
		
		//show next button
		echo "<a href='index.php?start=$next'>Next</a>";
		
		?>

So, i guess thats all the information that are needed..I hope that somebody could help me out coz i've been spending hours trying to fix this.

Thank You :)

Edited by samsons17: n/a

Attachments blogpost.png 58.19 KB database.png 26.04 KB
2
Contributors
2
Replies
4
Views
6 Years
Discussion Span
Last Post by samsons17
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.