my @nametape =( [24, 101], [25, 102], [23, 103], [21, 104], [26, 105], [22, 106], ); foreach $line (@nametape) { my @values = split(' ',$line); $products_id = $product_number; $options_id = 10; $options_values_id = $values[0]; $options_values_price = 0.00; $price_prefix = "+"; $products_options_sort_order = $values[1]; $query = $dbh->prepare(" INSERT INTO products_attributes (products_id, options_id, options_values_id, options_values_price, price_prefix, products_options_sort_order) VALUES ('$products_id', '$options_id', '$options_values_id', '$options_values_price', '$price_prefix', '$products_options_sort_order') "); $query->execute or exit; };