$query1 = $conn->prepare(q{SELECT name, email FROM ...}); $query1->execute(...); $query1->bind_columns( \my ($name, $email) ); while ($query1->fetch) { print "\nName: $name\nEmail: $email\n"; }