[AN-net]

i am still experiencing problems i need help

here is my updated code:

PHP Code:

            $countj= $DB_site->query_first("SELECT COUNT(*) AS journals FROM ".TABLE_PREFIX."journals WHERE active='1'");
            $perpage= 2;
            if(empty($page))
            {
                $page= 1;
            }
            $pagenumber = $page+1;
            if ($pagenumber < 1)
            {
                $pagenumber = 1;
            }
            else if ($pagenumber > $countj['journals'])
            {
                $pagenumber = $countj['journals'];
            }
            $start= (($page * $perpage) - $perpage);
            $pgnav= construct_page_nav($countj['journals'], "journal.php?", "&amp;pp=$perpage");
            $fjournals= $DB_site->query("SELECT
             journals.journal_id,journals.journalname,journals.journaldesc,
            journals.journalist,journals.journalist_id,journals.lastentry,
            journals.lastentry_date,journals.lastentry_id,journals.journalviews,
            journals.journal_totalrating AS totalrating,journals.journal_totalvotes AS totalvotes,COUNT(journal_entries.entry_id) AS entries
             FROM ".TABLE_PREFIX."journals
            LEFT JOIN journal_entries 
            ON (journals.journal_id=journal_entries.journal_id AND entry_active=1) 
            WHERE journals.active='1'  
            GROUP BY journals.journal_id 
            LIMIT $start,$perpage
            "); 


it seems as though my page is messing me up, it seems as though it affects my $start variable when i use ++ or +1 in the defining of $pagenumber. can someone help me define $pagenumber correctly