You are looking at a very old, but free version of the course. If you are interesed the most recent version, check it out on the Perl Maven site.

13.5. SELECT with more results

Example 13-3. examples/dbi/select_name.pl

#!/usr/bin/perl
use strict;
use warnings;

use DBI;

my $dbfile = "sample.db";

my $dbh = DBI->connect("dbi:SQLite:dbname=$dbfile");


my $sth = $dbh->prepare('SELECT fname, lname FROM users');
$sth->execute;

while (my @row = $sth->fetchrow_array()) {
    print "$row[0] $row[1]\n";
}

If you are interested in on-site trainings by the author, please contact me directly.