while (@results = $query1->fetchrow_array()) {
    foreach(@results) {

##</code><code>##

while (my ($name, $email) = $query1->fetchrow_array())
{
    print "\nName: $name\nEmail: $email\n";
}