Next/Prev

[Anon]

I need real help here. I read the tutorials on the next/prev links and they do not work. I keep getting errors everywhere. Anyways, I am making a Message board type script for my site, and I need help with this part. What I need to do is limit the number of posts on a page and make a next/prev button (without the 1 2 3 4). This is what I have for code and it works at the moment.

$link=mysql_connect("localhost");
if(!$link)die("Couldn't connect to MySQL");
mysql_select_db(acidsun,$link)or die("Couldn't select DB");
$result=mysql_query("SELECT ID,TopicID,name,post_name FROM posts WHERE TopicID=$TopicID ORDER BY TopicID DESC");
$num_rows=mysql_num_rows($result);
while($posts=mysql_fetch_array($result))
{
print "<a href=\"$PHP_SELF?PostID=$posts[ID]\">$posts[post_name]</a><br>";
}
mysql_close($link);
if ($num_rows<1)
{
print "<font size=\"2\">There are no Posts for this topic.</font>";
}

Im not good at making the Php code look all nice and stuff. I will work on that.

[chowdary]

Hi Ray,

Try this, i haven't tested it.
add this to your code just before while loop (after $num_rows)

  $max_records=5;
  $tot_pages=ceil($num_rows/$max_records);
  if (empty($page)){
         $page=1;
  }
  $start_rec=($page-1)*$max_records+1;
  $end_rec=$page*$max_records; 
  if ($page == 1){
      $prev_page = 1;
  } else {
      $prev_page = $page-1;
  }
  if($page == $tot_pages){
      $next_page = $page;
  } else {
      $next_page = $page + 1;
  }

In your while while loop use this

$count++;
if($count>=$start_rec && $count<=$end_rec)
{
   // print the data;

}

For your prev and next links (after while loop)

echo "<a href=\".........?page=$prev_page\">Prev</a>";

echo "<a href=\".......?page=$next_page\">Next</a>";

Hope this works for you

Cheers
Ajay