<?php
        //http://www.phpbuilder.com/board/showthread.php?t=10353797
        $host = "localhost";
        $user = "root";
        $pass = "";
        $db = "project";

    // open connection
    $connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");

    // select database
    mysql_select_db($db) or die ("Unable to select database!");

    // how many rows to show per page
    $rowsPerPage = 1;

    // by default we show first page
    $page_num = 1;

    // if $_GET['page'] defined, use it as page number, $_GET gets the page number out of the url
    //set by the $page_pagination below
    if(isset($_GET['page'])){$page_num = $_GET['page'];}

    //the point to start for the limit query
    $offset = $page_num;

    // Zero is an incorrect page, so switch the zero with 1, mainly because it will cause an error with the SQL
    if($page_num == 0) {$page_num = 1;}

    // counting the offset
    $sql = ("SELECT * FROM comments LIMIT $offset, $rowsPerPage");
    $res = mysql_query($sql) or die(mysql_error());

    // how many rows we have in database
    $sql2  = "SELECT COUNT(comment_id) AS numrows FROM comments";
    $res2  = mysql_query($sql2) or die(mysql_error());
    $row2  = mysql_fetch_array($res2);
    $numrows = $row2['numrows'];

    // print the random numbers
    while($row = mysql_fetch_array($res))
    {
        //Echo out your table contents here.

        echo $row[1].'<BR>';
        echo $row[2].'<BR>';
        echo '<BR>';
    }

    // how many pages we have when using paging?
    $numofpages = ceil($numrows/$rowsPerPage);

    // print the link to access each page
    $self = "events.php?";

    if ($numofpages > '1' ) {

                $range = 10; //set this to what ever range you want to show in the pagination link
                $range_min = ($range % 2 == 0) ? ($range / 2) - 1 : ($range - 1) / 2;
                $range_max = ($range % 2 == 0) ? $range_min + 1 : $range_min;
                $page_min = $page_num- $range_min;
                $page_max = $page_num+ $range_max;

                $page_min = ($page_min < 1) ? 1 : $page_min;
                $page_max = ($page_max < ($page_min + $range - 1)) ? $page_min + $range - 1 : $page_max;
                if ($page_max > $numofpages) {
                    $page_min = ($page_min > 1) ? $numofpages - $range + 1 : 1;
                    $page_max = $numofpages;
                }

                $page_min = ($page_min < 1) ? 1 : $page_min;

                //$page_content .= '<p class="menuPage">';

                if ( ($page_num > ($range - $range_min)) && ($numofpages > $range) ) {
                    $page_pagination .= '<a class="num"  title="First" href="'.$self.'page=1">&lt;</a> ';
                }

                if ($page_num != 1) {
                    $page_pagination .= '<a class="num" href="'.$self.'page='.($page_num-1). '">Previous</a> ';
                }

                for ($i = $page_min;$i <= $page_max;$i++) {
                    if ($i == $page_num)
                    $page_pagination .= '<span class="num"><strong>' . $i . '</strong></span> ';
                    else
                    $page_pagination.= '<a class="num" href="'.$self.'page='.$i. '">'.$i.'</a> ';
                }

                if ($page_num < $numofpages) {
                    $page_pagination.= ' <a class="num" href="'.$self.'page='.($page_num + 1) . '">Next</a>';
                }


                if (($page_num< ($numofpages - $range_max)) && ($numofpages > $range)) {
                    $page_pagination .= ' <a class="num" title="Last" href="'.$self.'page='.$numofpages. '">&gt;</a> ';
                }

                //$page['PAGINATION'] ='<p id="pagination">'.$page_pagination.'</p>';
            }//end if more than 1 page

    echo $page_pagination.'<BR><BR>';

    echo 'Number of results - '.$numrows ;
    echo ' and Number of pages   - '.$numofpages.'<BR><BR>';

    // Free resultset
    mysql_free_result($res);



?>