PHP pagination problem

So for some reason I am trying to figure out why my pagination isnt working properly. I get it to move from page 1 to 2 but it wont go to page 3 for some reason. I checked to see if the query from the DB was correct and it was so not sure where I am going wrong.

$per_page = '4';

$tenure_sql =  'SELECT COUNT(id) as count
                FROM people.bywu
                WHERE type <> 0
                AND status = "approved"';

$tenure_query = mysql_query( $tenure_sql, DB );

$tenure_count = mysql_fetch_object( $tenure_query );
$tenure_count = $tenure_count -> count;
$tenure_pages = ceil( $tenure_count / $per_page );

<div class="pagination" id="tenure_pages">
<a href="" class="lt grayed">&lt;</a>
Stories <span id="tenure_low" class="current_low"><?= $tenure_count ? '1':'0' ?></span>-<span id="tenure_high" class="current_high"><?= $tenure_count > 4 ? $per_page : $tenure_count ?></span> of <span class="total"><?= $tenure_count ?></span>
<a href="" class="gt<?= $tenure_count < 5 ? ' grayed':'' ?>">&gt;</a>
<span class="pages" style="display:开发者_如何学JAVAnone;"><?= $tenure_pages ?></span>
<?
    for( $i = 1; $i < $tenure_pages + 1; $i++ )
    {
    echo '<a href="">' . $i . '</a> ';
    } // for
?>

Scrapped away from kohana pagination class, i think you will find it useful if you know any basics about php classes.

Usage :

$pager = Pagination::factory(array('current_page' => $_GET['page'], 'total_items' => $total_items, 'items_per_page' => 20));

if ($pager->next_page) { /* etc.......*/ }

<?php
class Pagination {


    protected $config = array(
            'current_page'      => 1,
        'total_items'       => 0,
        'items_per_page'    => 10
    );

    // Current page number
    protected $current_page;

    // Total item count
    protected $total_items;

    // How many items to show per page
    protected $items_per_page;

    // Total page count
    protected $total_pages;

    // Item offset for the first item displayed on the current page
    protected $current_first_item;

    // Item offset for the last item displayed on the current page
    protected $current_last_item;

    // Previous page number; FALSE if the current page is the first one
    protected $previous_page;

    // Next page number; FALSE if the current page is the last one
    protected $next_page;

    // First page number; FALSE if the current page is the first one
    protected $first_page;

    // Last page number; FALSE if the current page is the last one
    protected $last_page;

    // Query offset
    protected $offset;

    /**
     * Creates a new Pagination object.
     *
     * @param   array  configuration
     * @return  Pagination
     */
    public static function factory(array $config = array())
    {
        return new Pagination($config);
    }

    /**
     * Creates a new Pagination object.
     *
     * @param   array  configuration
     * @return  void
     */
    public function __construct(array $config = array())
    {


        // Pagination setup
        $this->setup($config);

    }



    /**
     * Loads configuration settings into the object and (re)calculates pagination if needed.
     * Allows you to update config settings after a Pagination object has been constructed.
     *
     * @param   array   configuration
     * @return  object  Pagination
     */
    public function setup(array $config = array())
    {


        // Only (re)calculate pagination when needed
        if ($this->current_page === NULL
            OR isset($config['current_page'])
            OR isset($config['total_items'])
            OR isset($config['items_per_page']))
        {

            // Calculate and clean all pagination variables
            $this->current_page = (int) $this->config['current_page'];
            $this->total_items        = (int) max(0, $this->config['total_items']);
            $this->items_per_page     = (int) max(1, $this->config['items_per_page']);
            $this->total_pages        = (int) ceil($this->total_items / $this->items_per_page);
            $this->current_page       = (int) min(max(1, $this->current_page), max(1, $this->total_pages));
            $this->current_first_item = (int) min((($this->current_page - 1) * $this->items_per_page) + 1, $this->total_items);
            $this->current_last_item  = (int) min($this->current_first_item + $this->items_per_page - 1, $this->total_items);
            $this->previous_page      = ($this->current_page > 1) ? $this->current_page - 1 : FALSE;
            $this->next_page          = ($this->current_page < $this->total_pages) ? $this->current_page + 1 : FALSE;
            $this->first_page         = ($this->current_page === 1) ? FALSE : 1;
            $this->last_page          = ($this->current_page >= $this->total_pages) ? FALSE : $this->total_pages;
            $this->offset             = (int) (($this->current_page - 1) * $this->items_per_page);
        }

        // Chainable method
        return $this;
    }


    /**
     * Returns a Pagination property.
     *
     * @param   string  property name
     * @return  mixed   Pagination property; NULL if not found
     */
    public function __get($key)
    {
        return isset($this->$key) ? $this->$key : NULL;
    }

    /**
     * Updates a single config setting, and recalculates pagination if needed.
     *
     * @param   string  config key
     * @param   mixed   config value
     * @return  void
     */
    public function __set($key, $value)
    {
        $this->setup(array($key => $value));
    }

} // End Pagination

 ?>

Unless the count() you get from the database is 9 or larger, you'd never see a 3.

   ceil(0/4) -> 0
   ...
   ceil(8/4) -> 2
   ceil(9/4) -> 3

So... how many articles are there in the database that match the conditions in your query?

You don't show how you're passing around the "current page" count in your code, so how does the code know which page you're on at the moment?

$total_pages = 8;
$current_page = $_GET['curPage'];

for ($i = 1; $i <= $total_pages; $i++) {
   $class = ($i == $current_page) ? ' class="current"' : '';
   echo <<<EOL
<a href="page.php?curPage=$i"$class>$i</a>

EOL;
}