Gossamer Forum
Home : General : Perl Programming :

Re: [japh] SQL Query problem

Quote Reply
Re: [japh] SQL Query problem In reply to
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
Subject Author Views Date
Thread SQL Query problem Wil 5314 Jan 18, 2002, 10:17 AM
Thread Re: [japh] SQL Query problem
Paul 5154 Jan 18, 2002, 10:30 AM
Thread Re: [RedRum] SQL Query problem
Wil 5161 Jan 18, 2002, 10:34 AM
Thread Re: [japh] SQL Query problem
Wil 5167 Jan 18, 2002, 10:37 AM
Thread Re: [japh] SQL Query problem
lanerj 5153 Jan 19, 2002, 2:01 AM
Thread Re: [lanerj] SQL Query problem
Wil 5140 Jan 19, 2002, 10:14 AM
Thread Re: [japh] SQL Query problem
lanerj 5100 Jan 19, 2002, 8:31 PM
Thread Re: [lanerj] SQL Query problem
lanerj 5122 Jan 20, 2002, 1:47 AM
Post Re: [lanerj] SQL Query problem
Wil 5088 Jan 21, 2002, 4:12 AM