my $query = qq!
SELECT name FROM ata_members WHERE id = '$id'
!;
my $sth = $dbh->prepare($query) or &cgierr("Unable to query database. Reason: $DBI::errstr.");
$sth->execute or &cgierr("Unable to query database. Reason: $DBI::errstr. Query: $query");
my $name = $sth->fetchrow_array;
$sth->finish;
Bob
http://totallyfreeads.com
SELECT name FROM ata_members WHERE id = '$id'
!;
my $sth = $dbh->prepare($query) or &cgierr("Unable to query database. Reason: $DBI::errstr.");
$sth->execute or &cgierr("Unable to query database. Reason: $DBI::errstr. Query: $query");
my $name = $sth->fetchrow_array;
$sth->finish;
Bob
http://totallyfreeads.com