help me with the PAGINATION code

[raaman rai]

Please help me with the following code. I have used this pagination script from the net and customized it but unfortunately it doesnt work as expected. The problem is, for the trial purpose i have 3 records in the table and i have set the limit value to 2 only for now (for trial). So it is expected that i have 2 records displayed in the first page and 1 record in the second page. The first two records are displayed normally with the NEXT link. When i click on the NEXT link i get the third record but it is not actully the expected record as in my table. Instead the first record is displayed again. So, i feel there is a problem in the limit used in the second page. Please help me out.

 <?php   
           $searchstr=$_GET["class"]; 
         ?> 
         <h3>List of Class <?php echo $searchstr; ?> Contractors</h3>
         <br>
         <?php 
           $page=$_GET["page"];  
 
           if($page == "") $page=1; 
 
 
           $q="SELECT * FROM ".TBL_COMPANY." WHERE class='".$searchstr."' ORDER BY cdbno"; 
           $result = $database->query($q);
           $num_rows = mysql_num_rows($result); 
 
           $limit = 2;
           $pages=ceil($num_rows/$limit); 
 
           $query = "SELECT * FROM ".TBL_COMPANY." WHERE class='".$searchstr."' ORDER BY cdbno LIMIT " . ($page-1)*$limit . ",$limit";
           $searchresult = $database->query($query); 
           $numrows = mysql_numrows($searchresult);
 
           if(!$result || ($numrows < 0)){
              echo "Error displaying info";
           }
           if($numrows == 0){
              echo "<span class=\"info\">No Contractor information found for this Class</span>";
           }
           else
           {
         ?>
           <table width="100%">
             <tr>
               <td width="61" align="center" id="headstyle">CDB #</td>
               <td width="81" id="headstyle">Company</td>
               <td width="46" align="center" id="headstyle">Class</td>
               <td width="122" id="headstyle">Propietor</td>
               <td width="126" id="headstyle">Details</td>
             </tr>
         <?php
           for($i=0; $i<$numrows; $i++){
         ?>
             <tr>
               <td class="details" align="center"><?php echo mysql_result($result,$i,"cdbno"); ?></td>
               <td class="details"><?php echo mysql_result($result,$i,"company"); ?></td>
               <td class="details" align="center"><?php echo mysql_result($result,$i,"class"); ?></td>
               <td class="details"><?php echo mysql_result($result,$i,"propietor"); ?></td>
               <td class="details"><a href="process.php?viewprofile=true&&cdbno=<?php echo mysql_result($result,$i,"cdbno"); ?>"><strong>MORE DETAILS</strong></a></td>
             </tr>
         <?php
           }
         ?>
        </table>
         <?php 
           }
 
           $nav=""; 
           if($page > 1) { 
             $nav .= "<a href=\"displaycontractors.php?page=" . ($page-1) . "&class=" .urlencode($searchstr) . "\">
             << Prev&nbsp;&nbsp;&nbsp;</a>"; 
           } 
           for($i = 1 ; $i <= $pages ; $i++) { 
             if($i == $page) { 
               $nav .= "<B>$i</B>"; 
             }
             else
             { 
               $nav .= "<a href=\"displaycontractors.php?page=" . $i . "&class=" .urlencode($searchstr) . "\">
               &nbsp;&nbsp;&nbsp;$i&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</a>"; 
             } 
           } 
           if($page < $pages) { 
             $nav .= "<a href=\"displaycontractors.php?page=" . ($page+1) . "&class=" .urlencode($searchstr) . "\">
             &nbsp;&nbsp;&nbsp;Next >></a>"; 
           } 
           echo "<br><br>" . $nav; 
        ?> 
 

[code green]

The SELECT query generally uses ORDER BY DESC because ASC is default.
So the latest values are selected.
You generally specify a > greater than value or use BETWEEN.
The 'next' link passes the last highest value.
So the greater than value becomes the last highest value,

As the pagination develops you will probably find that you will also need to
store and pass between pages the current page number and the limit

[raaman rai]

thankyou, for your reply but i must say it didnt work. Plus i wanna inform you that i cannot use > or BETWEEN condition in my query cause its not relevant at all. Let me give you an idea i.e i am displaying a bunch of records from my table in order with the number specified (each number is unique for each contractor). So i want the records displayed in ASC order of its number. So i just want the records be displayed correctly in each page. Please help me further.

The SELECT query generally uses ORDER BY DESC because ASC is default.
So the latest values are selected.
You generally specify a > greater than value or use BETWEEN.
The 'next' link passes the last highest value.
So the greater than value becomes the last highest value,

As the pagination develops you will probably find that you will also need to
store and pass between pages the current page number and the limit

[code green]

I wasn't trying to give you a solution.
It was more of a guide to how pagination works because you do not seem to be applying the technique

use > or BETWEEN condition in my query cause its not relevant at all.

It is relevant in all pagination.
You just cannot see a use with only three records

So i want the records displayed in ASC order of its number

You can do this in php after you have got the results.
It looks to me that your LIMIT is pulling out the first rather than the last because ORDER BY is ASC