[williamh26]

I have this problem with a pagination... you can see at: Tutoring Online - www.chemath.com

this is my code

PHP Code:

<?php



   function showquestions($sub_id, $page, $currentpage, $newpage)

   {

      $query = "Select count(quest_id) from questions where sub_id = $sub_id";



      $result = mysql_query($query);

      $row = mysql_fetch_array($result);

      if ($row[0] == 0)

      {

         echo "<h2><br>Sorry, there are Questions in this category</h2>\n";



      }

      else

      {



         $thispage = $page;

         $totrecords = $row[0];

         $recordsperpage = 20;

         $offset = ($thispage - 1) * $recordsperpage;

         $totpages = ceil($totrecords / $recordsperpage);

         

         



         $query = "SELECT  quest_id, question, LEFT(question, 115) AS first115 from questions  WHERE sub_id=$sub_id ORDER BY question ASC LIMIT $offset,$recordsperpage";

         $result = mysql_query($query);

         while($row=mysql_fetch_array($result, MYSQL_ASSOC))

         {

            $quest_id = $row['quest_id'];



            $question = $row['question'];





            echo"<div id='content2'>";



            

            $extract = $row['first115'];

            // find position of last space in extract

           $lastSpace = strrpos($extract, ' ');

           // use $lastSpace to set length of new extract and add ...

           echo substr($extract, 0, $lastSpace).'... ';

          echo '<a href="details.php?quest_id='.$row['quest_id'].'"> More</a>';



            







            echo"</div>";



            echo"<br>";

            echo"<p>";



         }

         //echo "</table>\n";



         if ($thispage > 1)

         {

            $page = $thispage - 1;

            $prevpage = "<a href=\"$currentpage&cat=$sub_id&page=$page\"><h4>Previous page</h4></a>";

         } else

         {

            $prevpage = "";

         }





         if ($thispage < $totpages)

         {

            $page = $thispage + 1;

            $nextpage = " <a href=\"$currentpage&cat=$sub_id&page=$page\"><h4>Next page</h4></a>";

         } else

         {

            $nextpage = "";

         }



         if ($totpages > 1)

            echo $prevpage . "  " . $nextpage;



      }

   }

?>

Can you guys help me to have the next and previous links in every side of the page. THANKS