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