or download this
my $prod_dbh = DBI->connect_cached('DBI:Sybase:database','web_','web')
+ || die "Couldn't connect to DB!\n" . DBI->errstr;
my $parent_sth = $prod_dbh->prepare_cached('select * from table where
+id = ?');
$parent_sth->bind_param(1,$id);
$parent_sth->execute();
my @parent_data = $parent_sth->fetchrow_array();