Re: Counting fields from database

If all you want is a count of unique theadIDs, you can use a hash.

rows=$sth->rows;
%threads;
while (($pointer = $sth->fetchrow_hashref) && ($current_count_all <= $
+stopcount_all)){
       
    $threads{$pointer->{'threadID'}}++;    

}
my $threadCount = scalar keys %threads;
[download]

Comment on Re: Counting fields from database Download Code

Replies are listed 'Best First'.
Re^2: Counting fields from database by htmanning (Friar) on Oct 03, 2020 at 00:50 UTC
Thanks! Your example with the hash works but I still have to hit the database twice. Once to get the total threadcount and then again to print the content. I wasn't able to get it to work in one loop, but that's okay it works. Thanks.	[reply]
Re^3: Counting fields from database by BillKSmith (Monsignor) on Oct 03, 2020 at 18:29 UTC
Clearly you cannot print any counts until after you have read all the data at least once. As you read the DB, compute the counts and store all data (including counts) in a convenient data structure. Pass that structure to a subroutine which formats and prints it any way you like. Any data structure that saves all the data will 'work', but a well designed structure will greatly reduce the amount of code you must write. You have not told us enough about your data or your print requirements for us to offer much help. Bill	[reply]