The typical workflow is

my $sth = $dbh->prepare_cached($sql); # or simply ->prepare
$sth->execute(@arguments)
$sth->bind_columns(\my ($id, $name, other columns ...));

while ($sth->fetch) {
    print "$id: $name\n";
}
[download]