Ok, now I understand better. You are using an existing DB, not making one? You need to use the Perl DBI - Data Base Interface. There are links to the FAQ's and some tutorials. You can see some Monk links here: https://www.perlmonks.org/?node=Tutorials#Database-Programming.

A wild guess and some untested example code would be:
Instead of printing the link, you would use your code to download that doc, then do whatever you are going to do with it.

Update: I see that you are using MySQL instead of SQLite. Brain cramp on my part. But code is essentially the same - just a difference in how to get the DB connection. The dbi would be: dbi::MySQL, then you need an account and password. For SQLite, these are null strings. See the doc's referenced above for a connection example with username/password. 

#!/usr/bin/perl
use warnings;
use strict;
use Data::Dumper;

use DBI qw(:sql_types);

my $dbfile  = "./YourDbName.sqlite";
my $dbh = DBI->connect("dbi:SQLite:dbname=$dbfile","","",{RaiseError =
+> 1})
    or die "Couldn't connect to database: " . DBI->errstr;
    
    
my $get_links_4date_sql = "SELECT Identifer, LINK
                           FROM    YourTableName
                           WHERE   Publish date IS ?");

my $get_links_4date = $dbh->prepare ($get_links_4date_sql);

my $date = "20220701";

$get_links_4date->execute($date);
my $array_ref = $get_links_4date->fetchall_arrayref;

foreach my $row_ref (@$array_ref)
{
   my ($id,$link) = @$row_ref;
   
   print "$id \t $link\n";
}

[download]
I can't anticipate exactly what kind of SQL you need. Above just gets docs for a particular date. Although sounds like what you need is: for each unique id, download latest version of the document. The SQL for that is of course more involved but doable.

Hope this gets you further along your way.

In reply to Re^3: Combining Ffile:fetch with MySQL by Marshall
in thread Combining Ffile:fetch with MySQL by justin423

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.