while(($one, $two, $three) = $sth->fetchrow_array) {
    # $one, $two and $three are columns a, b and c
}