cheers,
well the script know of all active products at the now state and all historical active products, that may be inactive or still active.
anyway i need to treat both of them, if someone wants to edit old data it shoud add the now active products to the historical ones.
with prebuilding the array with total_pid i get sure all,historical and now, products are in there ;), gives me a better feeling ^^.
when i only run ym_cty_product i may miss a product.
when i update/ insert into the database without the first run (empty values i miss some data in db, can be my update/insert sub but with first run everything looks fine in db
please correct me if i don't get somthing wrong because im quit new into these HoH and so on ^^

kd ultibuzz

PS: the data can not be entered in the wrong cell because each cell contains a sup and product, so every value is unique accesible.
i'will post my table creation tomorrow from office, i think this makes it clearer then my PS ^^

Update: here is my table code looks a bit messy but it works ^^

foreach my $row (@total_sup) {
        my $sup = Get_Supplier_Name($row);
        print qq(<td align="center" bgcolor="#7E7E7E" colspan="2"><b>$
+sup</b></td>);
}
print qq(</tr><tr><td align="center" bgcolor="#7E7E7E"><b>Product Name
+</b></td>);
print qq(<td align="center" bgcolor="#7E7E7E"><b>Flag</b></td>);
foreach my $row (@total_sup) {
        print qq(<td align="center" bgcolor="#7E7E7E"><b>Front End</b>
+</td>);
        print qq(<td align="center" bgcolor="#7E7E7E"><b>Solid Sales</
+b></td>);
}
print qq(</tr>);
foreach my $row (@total_pid) {
        my $sups = scalar(@total_sup);
        my $prod_name = Get_Product_Name($row,$group);
        print qq(<tr><td align="center" bgcolor="#FFFFFF"><input type=
+"hidden" name="prod_id" value="$row">$prod_name</td>);
        print qq(<td align="center" bgcolor="#FFFFFF"><input type="hid
+den" name="flag" value="$rowhash{$row}{'FLAG'}">$rowhash{$row}{'FLAG'
+}</td>);
        for (my $i=1;$i<=$sups;$i++) {
                print qq(<td align="center" bgcolor="#FFFFFF"><input t
+ype="text" name="sup_f_$now_sup[$i-1]" value="$rowhash{$row}{$now_sup
+[$i-1]}{'DATA_F'}" size="10"></td>);
                print qq(<td align="center" bgcolor="#FFFFFF"><input t
+ype="text" name="sup_s_$now_sup[$i-1]" value="$rowhash{$row}{$now_sup
+[$i-1]}{'DATA_S'}" size="10"></td>);
        }
        print qq(</tr>);
}
my $col_span = (scalar(@now_sup)*2)+2;
print qq(<tr><td align="center" bgcolor="#7E7E7E" colspan="$col_span">
+<input type="submit" value="    SAVE    "></td></tr>);

[download]

In reply to Re^3: dynamic website, putting data into right tablefield's by ultibuzz
in thread dynamic website, putting data into right tablefield's by ultibuzz

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.