use DBI;  # Here's how to include the DBI module

my $dbh;

my $db = 'myfirstdatabase'; 
my $db_user = 'RAM'; 
my $db_password = ''; 

# Connect to the requested server 

$dbh = DBI->connect ("dbi:mysql:$db","$db_user", "$db_password",{Raise
+Error => 0, PrintError => 0} ) or err_trap("Cannot connect to the dat
+abase");
my $sql;
my $sth;
$sql = "SELECT max(unxtmstmp) FROM logfl";
      
$sth=$dbh->prepare($sql) or die "preparing: ",$dbh->errstr;
$sth->execute or die "executing: ", $dbh->errstr;
@$d = $sth->fetchrow_array;
print "@$d";
[download]

This program works for me, once I change $db, $db_user, $db_password, and $sql to something that exists on my system. Also I had to add a subroutine for err_trap(). Do you have the DBD::mysql module installed?

hi davorge

i installed all the modules which u had mentioned and even now when i am

trying to install i am getting this message

C:\>ppm

PPM - Programmer's Package Manager version 3.1.

Copyright (c) 2001 ActiveState SRL. All Rights Reserved.

Entering interactive shell. Using Term::ReadLine::Stub as readline library.

Type 'help' to get started.

ppm> install dbi

Note: Package 'DBI' is already installed.

ppm> install dbd-mysql

Note: Package 'DBD-mysql' is already installed.

ppm>