I think my logic is flawed. This is a better example of what I'm doing:

This is the query of the database: 

Select * from messages where (username='$username' or toname='$usernam
+e') and message!='' order by dateadded desc, ID desc

[download]
This follows: 
        $titlesperpage = 10;
        $currentpage = 1;
        $startcount = ($currentpage - 1) * $titlesperpage + 1;
        $stopcount = $currentpage * $titlesperpage;
        $current_count = 0;
        $threadcount=0;
        $threadIDlist = "";
         while ($pointer3 = $sth3->fetchrow_hashref){
            $current_count++;
            $threadID = $pointer3->{'threadID'};
            $threads{$pointer3->{'threadID'}}++; 
            
            
                if ($threadIDlist !~ /$threadID/) {
                    $threadIDlist=$threadID . "," . $threadIDlist;
                    $current_count--;
                    $threadcount++;    
                 }
                 
           }

[download]
I try to only print 10 records per page. It works perfectly for the first page, but when I come back to print the second page it duplicates some threadIDs because they are not yet in the $threadIDlist var. The second page is called with this query_string: 
?currentpage=2

[download]

In reply to Re^2: Counting fields from database (updated) by htmanning
in thread Counting fields from database by htmanning

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.