$sth = $dbh->prepare("select a, b, c from foo");
$sth->execute;
while($row = $sth->fetch) {
    # $row->[0] is column 'a'
    # $row->[1] is column 'b', 
    # etc...
}