print $query->table({-ALIGN=>'CENTER', BORDER=>''}, Tr({-bgcolor=>'#9933FF', -valign=>'TOP'}, [ th({-width=>'20%', -align=>'center'}, 'PLAYER NAME').th({-widt +h=>'30%', -align=>'center'}, 'ADDRESS').th({-width=>'20%', -al ign=>'center'}, 'PHONE NUMBER').th({-width=>'200', -align=>'center'}, +'FATHER').th({-width=>'200', -align=>'center'}, 'MOTHER').th({ -width=>'100', -align=>'center'}, 'DATE OF BIRTH').th({-width=>'100', +-align=>'center'}, 'ASSOCIATION').th({-width=>'50', -align=>'c enter'}, 'NUMBER').th({-width=>'50', -align=>'center'}, 'POSITION').th +({-width=>'25', -align=>'center'}, 'SHOOTS'), ] ) ); while (my @val = $sth->fetchrow_array ()) { print $query->table({-ALIGN=>'CENTER', BORDER=>''}, Tr({-bgcolor=>'#99FF99', -valign=>'TOP'}, [ td({-width=>'20%', -align=>'center'}, $val[0]).td({-width=>'30 +%', -align=>'center'}, $val[1]).td({-width=>'20%', -align=>'ce nter'}, $val[2]).td({-width=>'200', -align=>'center'}, $val[3]).td({-w +idth=>'200', -align=>'center'}, $val[4]).td({-width=>'100', -a lign=>'center'}, $val[5]).td({-width=>'100', -align=>'center'}, $val[6 +]).td({-width=>'50', -align=>'center'}, $val[7]).td({-width=>' 50', -align=>'center'}, $val[8]).td({-width=>'25', -align=>'center'}, +$val[9]), ] ) ); print $query->end_html(); } $query->start_table({-ALIGN=>'CENTER',}), $query->start_Tr({-bgcolor=>'#9933FF', -valign=>'TOP', -align= +>'center'}), $query->start_th({-align=>'center',}), "PLAYER NAME", $query->start_th({-align=>'center',}), "ADDRESS", $query->start_th({-align=>'center',}), "PHONE NUMBER", $query->start_th({-align=>'center',}), "FATHER", $query->start_th({-align=>'center',}), "MOTHER", $query->start_th({-align=>'center',}), "BIRTH-DATE", $query->start_th({-align=>'center',}), "ASSOCIATION", $query->start_th({-align=>'center',}), "NUMBER", $query->start_th({-align=>'center',}), "POSITION", $query->start_th({-align=>'center',}), "SHOOTS", $query->end_th, $query->end_Tr; while (my @val = $sth->fetchrow_array ()) { print $query->start_Tr({-bgcolor=>'#99FF99', -valign=>'TOP', -align= +>'center'}), $query->start_td({-align=>'center',}), $val[0], $query->start_td({-align=>'center',}), $val[1], $query->start_td({-align=>'center',}), $val[2], $query->start_td({-align=>'center',}), $val[3], $query->start_td({-align=>'center',}), $val[4], $query->start_td({-align=>'center',}), $val[5], $query->start_td({-align=>'center',}), $val[6], $query->start_td({-align=>'center',}), $val[7], $query->start_td({-align=>'center',}), $val[8], $query->start_td({-align=>'center',}), $val[9], $query->end_Tr; } $query->end_table, $query->a({-href=>'Roster.pl'}, h2('ROSTER'),), print $query->end_html;
In reply to Re: Re: Re: Re: Using the mysql database columns as the table header.
by mnlight
in thread Using the mysql database columns as the table header.
by mnlight
| For: | Use: | ||
| & | & | ||
| < | < | ||
| > | > | ||
| [ | [ | ||
| ] | ] |