With the CGI.pm there are at least two ways to construct tables.  Rather than try to keep up with all of those brackets and parenthesis, try this format:

print $query->header(-type=>'text/html'),
$query->start_html(-title=>'My Web Page'),
$query->start_table({-border=>'0', -width=>'400'),
$query->start_Tr,
$query->start_td({-align=>'left', -width=>'100%',
                  -colspan=>'1'),
"Header", "\n",
$query->end_td, $query->end_Tr;

while(something) {
   somecode;
   somecode;

   # Loop around and fill in table data

   print $query->start_Tr,
   $query->start_td({-align=>'left', -width=>'100%',
                     -colspan=>'1'),
   "Some Data", "\n",
   $query->end_td, $query->end_Tr;
}  #End while statement

# Close out table and web page

print $query->end_table,
$query->end_html;

[download]

As you can see, you can start a table and table rows and table data cells without having to complete them.  This method allows your HTML calls within your while statement to act without consideration of the heading section of your table.  It also allows you to create the page with only one table.  Incidentally, there are more property settings to the table statement (i.e., cellpadding) and the start_html command;  and the start_td command doesn't require colspan to be set--I just wanted to show you how to do it.  I also should point out that for start_Tr and end_Tr, the "T" is capitalized.

That's Spenser, with an "s" like the detective.

In reply to Re: Using the mysql database columns as the table header. by Spenser
in thread Using the mysql database columns as the table header. by mnlight

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.