Why did you repost your complete post another program, with the comments that do not help anything, and with code parts that you still fail to explain, which I told you do nothing, but which you still keep in your program?

What reaction do you expect from me?

When you fetch data and put it into an array. It does not index it. It is all placed in array index 0. I want to index the data. In terms of a data dump my code already does that....The data trace(2) says that it is keeping the first array. The emailed data says it is keeping the first array.

Until you use Data::Dumper, I won't believe that you output your complete datastructure.

Can you pass an array index to a sql statement via a loop to get more specific data? That is all I want to know. Can sql passed an array indexed value with each iteration? That is my only question. If it can't be done that is fine... but The data structure has been dumped and validated. I know how to dump data and create and entance to view the data structure.

Whatever you mean by "index". You get all your data back as an array of arrays (AoA). The Perl documentation I already referred you to, perldsc and perlreftut, describe what that is. If you have "dumped and validated" the data structure, then I wonder why you feel the need to ask for the rest of your data.

Update: Please see brian's Guide to Solving Any Perl Problem for further help in debugging your problems.

In reply to Re^9: SQL query using dynamic array by Corion
in thread SQL query using dynamic array by cocl04

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.