Results 1 to 2 of 2

Thread: [RESOLVED] pagination help

Threaded View

  1. #1

    Thread Starter
    Fanatic Member stickman373's Avatar
    Join Date
    Mar 2001
    Location
    MA
    Posts
    909

    [RESOLVED] pagination help

    http://www.ekc-solutions.com/propertybbs/test.php

    if you go to the page above you can see it does the pagination, but is there a way to show the first 10 page links like

    < 1 2 3 4 5 6 7 8 9 .. 90 >>

    something like that?

    Here is the code:

    Code:
    if(!isset($_GET['page'])){
        $page = 1;
    } else {
        $page = $_GET['page'];
    }
    
    // Define the number of results per page
    $max_results = 10;
    
    // Figure out the limit for the query based
    // on the current page number.
    $from = (($page * $max_results) - $max_results);
    
    // Perform MySQL query on only the current page number's results
    
    $sql = mysql_query($totalquery." LIMIT $from, $max_results");
    
    while($row = mysql_fetch_array($sql)){
        // Build your formatted results here.
        echo $row['title']."<br />";
    }
    
    // Figure out the total number of results in DB:
    $total = mysql_query($totalquery);
    $total_results = mysql_num_rows($total);
    
    // Figure out the total number of pages. Always round up using ceil()
    $total_pages = ceil($total_results / $max_results);
    
    // Build Page Number Hyperlinks
    echo "<center>Select a Page<br />";
    
    // Build Previous Link
    if($page > 1){
        $prev = ($page - 1);
        echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$prev\"><<Previous</a>&nbsp;";
    }
    
    
    
    for($i = 1; $i <= $total_pages; $i++){
        if(($page) == $i){
            echo "$i&nbsp;";
            } else {
                echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$i\">$i</a>&nbsp;";
        }
    }
    
    // Build Next Link
    if($page < $total_pages){
        $next = ($page + 1);
        echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$next\">Next>></a>";
    }
    echo "</center>";
    Last edited by stickman373; Dec 11th, 2004 at 02:24 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width