Page Numbering

Dillenger

Why doesn't this work?

                <?PHP

		  require('admin/config.inc');
		  $cid = mysql_connect($host,$usr,$passwd);
		  $select_db = mysql_select_db($db); 

		  if(!$rowstart) $rowstart=0;

		  $sql = "select * from x_news ORDER BY id DESC";

		  $result = mysql_query($sql);
		  $result2 = mysql_query("select * from x_news");

		  while ($directory = mysql_fetch_array($result)) { 

		$id = $directory['id']; 
		$entry = $directory['entry'];
		$day = $directory['day'];
		$month  = $directory['month'];

		echo "<img src='$month'><img src='$day'><br><br>";
		echo "$entry<br><br>";

}
			  if ($rowstart>$numrows) 
{?>
              <A HREF="<? $php_self ?>?rowstart=<? echo $rowstart-2;?>"> < Previous 
              Page</A> 
              <? } ?>
              | 
              <?

$numrows=mysql_num_rows($result2);
if($rowstart+2<$numrows) 
{?>
              <A HREF="<? $php_self?>?rowstart=<?echo $rowstart+2 ;?>"> Next Page 
              ></A> 
              <? } ?>

bad76

Hi,
you don't tell to mysql what page has to do...

if(!$rowstart) $rowstart=0; 
$sql = "select * from x_news ORDER BY id DESC";

You have to add the string " LIMIT $rowstart,num" at your query.
This for example show 2 news each time:

if(!$rowstart) $rowstart=0; 
$sql = "select * from x_news ORDER BY id DESC LIMIT $rowstart,2";

P.S:just any hint, i think better not use $result2 in your code, is enough $result...

cgraz

Dillenger: Your question is really vague. You'd get more responses if you were more specific in your questions. Just posting code usually drives people away from wanting to read the post.

Anyways, here's some code I wrote a while back for a guy on doing the next previous thing. It's 100% commented, so use it to your hearts content. There are plenty of ways to do the next previous script, but this is my way and it's all commented so that you can follow easily.

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10219415

Good luck.

Cgraz