Bart Lateur writes: > [beginners list snipped] > > On Fri, 11 Jan 2002 11:40:03 +0100, Marius Keraitis wrote: > > >Second step is to show every table contents (by clicking on link with table > >name). > >To do this I need to know how many columns is in table, and all names of columns > >in table. > > You can do (very portable): > > my $sth = $dbh->prepare("SELECT * FROM $table");
I would add WHERE 1=0 there to make sure that no actual rows are fetched (although that may not work on all database servers it's a common idiom). Michael -- Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler [EMAIL PROTECTED] - [EMAIL PROTECTED] International Sybase User Group - http://www.isug.com