Spanning records over multiple pages

[akuma]

Hi, I have a MySql table with around 40 records... basicly I want to split it up so it displays 10 records per page with a listing such as "1 | 2 | 3" that is generated on each page so you can click and view whatever page you want. Anyone have any ideas on how to do this or know of any decent code examples? Thanks!

[littleelmo]

I think you will find what you 're looking for from this article

http://phpbuilder.com/columns/rod20000221.php3

Hope that helps

[Anon]

heres a function i use. i like it alot.

$offset = first row to show
$limit = how many rows shown from offset
$num_rows_all = total rows in table
$link_args = any args needed to be passed on in url

hope it helps..

function jump_to($offset, $limit, $num_rows_all, $link_args)
{
global $PHP_SELF;

$offset_back = $offset - $limit;
$offset_next = $offset + $limit;
$num_pages = ceil($num_rows_all/$limit);

if($num_pages > 1)
{
    $current_page = $offset/$limit;
    $jump_to = "<b>Navigation:</b>&nbsp;[";

    if($offset_back >= 0)
    {
        $jump_to.="&nbsp;<b><a href='$PHP_SELF?$link_args&offset=$offset_back'>Back</a></b>";
    }
    for($page=0; $page<$num_pages; $page++)
    {
        if( ($current_page-5) < $page && ($current_page+5) > $page )
        {
            $offset_page = $page * $limit;
            $page_num = $page+1;

            if($current_page==$page)
            {
                $jump_to.="&nbsp;<b>$page_num</b>";
            }
            else
            {
                $jump_to.="&nbsp;<a href='$PHP_SELF?$link_args&offset=$offset_page'>$page_num</a>";
            }
        }
    }
    if( $offset_next <= $num_rows_all )
    {
        $jump_to.="&nbsp;<b><a href='$PHP_SELF?$link_args&offset=$offset_next'>Next</a></b>";
    }
    $jump_to.="&nbsp;]";
}

return $jump_to;

}

-paul
http://xhawk.net

[akuma]

Wow... I searched here before I asked, cant believe I totaly missed that article, thanks for the help, I got it working!