while ( my @order_fields= $query->fetchrow_array() ) {
   my $ordernumber = $order_fields[0] or die "Error: Expected a non-zero order number" ;
   my $url = "link.com/$ordernumber";
   ...
}