in reply to perl-mysql help - print table structure

The replies at Perl and Mysql! should be of help to you. If not, feel free to ask specific questions about displaying database tables. (like what output format do you want, do you want to display columns or just the data, etc.)

One more item ... i don't like the way you pass around global variables like that. If you really want to use a global because passing variables to subs is tedious, just slam your config vals into a hash: 

my %conf = (
   db_type => 'mysql',
   db_name => 'new_db',
   db_user => 'root',
   db_pass => '****',
   table   => 'profile',
);

[download]
That is much easier to handle.

jeffa

L-LL-L--L-LL-L--L-LL-L--
-R--R-RR-R--R-RR-R--R-RR
B--B--B--B--B--B--B--B--
H---H---H---H---H---H---
(the triplet paradiddle with high-hat)

In Section Seekers of Perl Wisdom