my $sth_news = $dbh->prepare(" SELECT id, body FROM news "); $sth_news->execute; $sth_news->bind_columns(\my $news_id,\my $news_body); my $sth_comments = $dbh->prepare(" SELECT COUNT(id) FROM comments WHERE id = ? "); while ($sth_news->fetch) { $sth_comments->execute($news_id); $sth_comments->bind_columns(\my $comments); $sth_comments->fetch; print "$news_id, $news_body, $comments"; }