$sth->execute();
$sth->bind_columns(\my ($col1, $col2, $col3));
while ($sth->fetch()) {
  print "$col1 $col2 $col3\n";
}