--------------------------------------------------------- |Name | Address | Tel | Email | --------------------------------------------------------- | Bob | 1 London Road | 00000000000 | bob@london.co.uk | --------------------------------------------------------- | Tony | 10 Downing St | 99999999999 | tony@no10.co.uk | --------------------------------------------------------- #### Name: Bob Address: 1 London Road Tel: 00000000000 Email: bob@london.co.uk Name: Tony Address : 10 Downing St Tel: 99999999999 Email: tony@no10.co.uk #### use DBI; # my $sql = "SELECT * FROM win32_processor"; my $sql = "SHOW FIELDS FROM win32_processor"; # Connect to the database. if (! saracen_open_database_connection ( \$dbh, $program_config{saracen_database}, $program_config{saracen_admin_login}, $program_config{saracen_admin_pass} ) ) { # Indicate that a problem occured. return 0; } if (! saracen_execute_query(\$dbh, \$sth, $sql)) { return 0; } #output database results while (@row = $sth->fetchrow_array) { print "@row\n" }