in reply to Re^5: Help with MySQL SELECT into multidimensional array
in thread Help with MySQL SELECT into multidimensional array

I did some more reading around this, my SQL-fu is way more advanced than my Perl-fu, so I went about it with views, which worked great. Now I have a very simple query which outputs everything that I need, literally as simple as:

SELECT * from view;

So now my quest becomes to work out how to spit out an HTML table from my Perl array.

This is a great step forwards on my path to enlightenment, and I thank everyone for their help so far!

Replies are listed 'Best First'.
Re^7: Help with MySQL SELECT into multidimensional array
by Marshall (Canon) on Dec 06, 2011 at 10:50 UTC
    This is GREAT! My SQL-fu is mediocre. But with the DBI there is often a trade-off between SQL-fu and Perl-fu! I'm glad that you are on your way!

    I've got a DB project underway and may need some help with views. But that is another subject. If you need help with HTML, start a new thread independent of the DB stuff.

    Glad that the Monks could help you!