Instead of using this logic of $index, why can't you simply print the name and email column by using something like this:

my @results;
while (@results = $query1->fetchrow_array()) {
    print "Name : $results[1], Email: $results[2]\n";
}
[download]

Generally, first row consist of ID. That's why, Here I'm assuming that after ID the 1st column is for name and 2nd column is for email address. Please, use the correct column number as in your table.

Also, for printing all the rows, you can use like this:

my @results;
while (@results = $query1->fetchrow_array()) {
   foreach my $r (@row) {
    print "$r\n";
   }
}
[download]

let me know if you still have any query.

Regards, CKJ