dear members,

i have some problems to fetch the data from a mysql database generated with phpmyadmin. i'm a beginner in programming in perl. i'm nit sure whther i chose a well formed expression to refer to the database. here is the code:

$dbh = DBI->connect("DBI:mysql:c\programme\xampp\mysql\data\lexikon;localhost","myusername","mypassword")
or die "Keine Verbindung möglich: " . $DBI::errstr;
$sql = "select * from v";
$dbh->prepare($sql)
or die "prepare nicht möglich: " . $dbh->errstr();
$sth->execute()
or die "execute nicht möglich: " . $sth->errstr();
while (@row = $sth->fetchrow_array) {
print "@row\n";
}
$sth->finish;
$dbh->disconnect;

after having processed this code i exspect the engine to print the values stored in table "v". this code is part of a cgi-script which shall be used to a database which contains a thesaurus and to check whether

Reply via email to