pages..

jebster

First off I know this question is asked alot! Sorry!
I'm making a guestbook and have it so you can only display a certain numer of posts per page from the config file. But I don't know how to make the next and previous pages? Also it shows the posts in deceding(sp?) order so the newest is on the top of the first page!
What I would like the page nav to be like is this:

<< 1 2 3 4 ... 30 >>

Where "<<" is previous and >> is next and "30" would be the last page and would like to make the current page # bold! Altho just next and prev is good enough.

Thanks 🙂

Weedpacket

Er...if you know the question is asked a lot, why don't you read some of the answers? 😕

jebster

Originally posted by Weedpacket
Er...if you know the question is asked a lot, why don't you read some of the answers? 😕

Cause I'm alittle on the slow side :o Easier if someone just gives you the answer LOL

I'm working on it but its kinda hard! Like on the last page when I don't want the link to show up as a link anymore cause there is no more posts to display and such. But I'm getting there!

jebster

Right now I'm haaving some problems with this

if($page+$post_per_page > $num_rows) {
some stuff in here
} else {
some other stuff in here
}

The value of $page is 15 and $post_per_page is also 15 and the value of num rows is 51 but it still does the stuff in if not else! What am I doing wrong here?

Weedpacket

Well, unless cosmic rays have fried your processor in new and exciting ways, it would reckon that 15+15<=51. So a reasonable suspicion is that one of $pages, $post_per_page or $num_rows does not have the claimed value.

var_dump($page, $post_per_page, $num_rows);
if($page+$post_per_page > $num_rows) {
some stuff in here
} else {
some other stuff in here
}

Incidentally, wouldn't you want $page*$post_per_page? If you have 15 pages and 15 posts per page, isn't that a total of 225 posts?

jebster

I feel so stupid.... :o

And its not 15 pages.. Guess I should change $page to $post or something.. See:

$result = mysql_query("SELECT * FROM $table1_name ORDER BY poster_time DESC LIMIT $page, $post_per_page",$link);

And yea, this is the first script besides crappy little ones for my site I have made so I kinda get confused some times cause there is hundreds and hundreds of lines of code(not all php tho, some is html of course..)!

jebster

<?php
$link = mysql_connect("$database_host","$database_username","$database_pass")or die("Connect Error: ".mysql_error());
mysql_select_db("$database_name",$link); 
$num_rows = mysql_num_rows($result);
if ($show == all) {
		print "<div align=\"right\" class=\"comment2\">No other pages</div>";
} else {
	if($page) {
		if($page+$post_per_page < $num_rows) {
		$prev = $page-$post_per_page;
		print "<div align=\"right\" class=\"comment2\"><a href=\"$PHP_SELF?page=$prev\">Prev.</a></div>";
		$next = $page+$post_per_page;
		print "<div align=\"right\" class=\"comment2\"><a href=\"$PHP_SELF?page=$next\">Next.</a></div>";
		} else {
		$prev = $page-$post_per_page;
		print "<div align=\"right\" class=\"comment2\"><a href=\"$PHP_SELF?page=$prev\">Prev..</a></div>";
		print "<div align=\"right\" class=\"comment2\">Next..</div>";
		}
	} else {
		print "<div align=\"right\" class=\"comment2\">Prev...</div>";
		$next = $post_per_page;
		print "<div align=\"right\" class=\"comment2\"><a href=\"$PHP_SELF?page=$next\">Next...</a></div>";
	}
}
mysql_close($link);  

?>

Is there anything wrong with that code?

Values are $page =15 $post_per_page = 15 $num_rows = 51
Yet the script does this one:

		 else {
		$prev = $page-$post_per_page;
		print "<div align=\"right\" class=\"comment2\"><a href=\"$PHP_SELF?page=$prev\">Prev..</a></div>";
		print "<div align=\"right\" class=\"comment2\">Next..</div>";
		}

Proably just another dumb mistake on my part tho!

jebster

Anyone?

jebster

Once again I feel like a complete idoit! Took me like 3 or more hours to notice I didn't have

$result = mysql_query("SELECT * FROM $table1_name",$link);

In there and the reason it wasn't working was cause it was using $result from this which is used earlier in the script

  $result = mysql_query("SELECT * FROM $table1_name ORDER BY poster_time DESC LIMIT $page, $post_per_page",$link);

Such and idiot...:o

jebster

one more quick question!

I have this

$total_pages = $num_rows/$post_per_page;

and the answer is 3.4! how would I round that up to 4?

Weedpacket

Quick answer: [man]ceil[/man]

jebster

Cool! Thanks! 🙂