Auto table generation

Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

Hello fellow monks.

Say you have a database full of goodies, which you'll need to use pageification on eventually. How would one go about displaying a table X by X cells pulled from a dynamic db/array in such a smart fashion it'll know when it's run out of data and knows when to close the td/trs/table?

I'm currently trying to display 5x5 html table cells with things pulled from mysql. Can someone give some code and some suggestions on how to do this and have it finish off the row it's on and close all extra TD's if there isn't enough input to go across all 5 columns?

Comment on Auto table generation

Replies are listed 'Best First'.
Re: Auto table generation by wfsp (Abbot) on May 10, 2008 at 07:29 UTC
HTML::Template nested loops, DBI/MySQL and map doesn't output tables but could very easily be adapted to do so. The mighty DBI has methods that return data structures that match just the type of input that HTML::Template requires. Note the replies in the above thread that greatly improve on my initial attempt.	[reply]
Re: Auto table generation by apl (Monsignor) on May 10, 2008 at 15:24 UTC
Have you broken down the problem into pieces? Can you show any code or pseudo-code?	[reply]