#!/bin/perl -w
use DBI;
use diagnostics;
use strict;
use CGI::Pretty qw(:all);
my ($dbh,$sth);
my ($dbname)="test";
my ($login)="who_am_i";
my ($password) ="secret_word";
my ($query);
my ($cl_first_name);
# Define query
$query=qq(SELECT cl_first_name from client);
#
$dbh = DBI->connect("DBI:mysql:$dbname",$login,$password)
	or die "Can't connect to $dbh: $dbh->errstr\n";
$sth = $dbh->prepare("$query")
	or die "Can't connect to $dbh: $sth->errstr\n";
$sth-> execute()
	or die "Can't connect to $dbh: $sth->errstr\n";

print start_html({-title=>"CGI Table"});
print table(
while (($cl_first_name) = $sth -> fetchrow_array())
{
Tr([td([$cl_first_name])])
}
);
$dbh->disconnect();
print end_html;