Hello - I'm new to Perl. Trying to set up a loop to call a series of lines to submit to SQL I've already assigned $line1, $line2, $line3 etc with sql queries to run on the database. The problem is perl doesn't seem to like $linename.$counter

my $line1 = "use pricedb;";
my $linename = "line";

my $dbh = DBI->connect("DBI:mysql:host=localhost;database=mysql","root
+","root");


# set up a loop to make submitting lines easier  ;

  for(my $counter = 1; $counter <=10; $counter ++)
      {
       
        my $concatline = $linename.$counter;
        my $rowsaffected = $dbh ->do(${$concatline});
        if ($rowsaffected && $rowsaffected == 0E0)
            {
              print "Operations ws successful but no rows were affecte
+d \n";
            }
        elsif($rowsaffected)
            {
              print "Operation was successful ($rowsaffected rows)\n";
            }
        else
            {
              print "Operation failed: $DBI::errstr\n";
            }
      }
        
   $dbh -> disconnect;
[download]

Please advise how I get the loop to pull $line1, $line2 etc? NB I'm very new to Perl so would appreciate v simple suggestions - my previous experience is SAS, Matlab and a little VBA..Thanks!!

---

---

• Are you posting in the right place? Check out Where do I post X? to know for sure.
• Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:

  <code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>

• Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
• Want more info? How to link or How to display code and escape characters are good places to start.