i.e. use DBI; use strict; use vars qw($value);.......... while ($i<=2) { print "$array[$i]\n"; $value = "$array[$i]"; print "$value\n"....... ############################ # # Set up Query for Store # ############################ my $stmt = "select week_end_date, SVP, RD, DM, store, wtd_smrr_gain,QTD_SMRR_GAIN, wtd_bor_gain,QTD_BOR_GAIN, wtd_cust_gain,QTD_CUST_GAIN, WTD_CARD_CLOSED,QTD_AVG_CARD_CL from bonus_4Q_store where SVP <> 'RD' and RD = '$value' order by svp,dm,store"; ...... $i++...... };