Re: Get hash of MySQL row

2002-02-12 Thread Wiliam Stephens
> On Wed, Feb 06, 2002 at 01:57:21PM +, Wiliam Stephens wrote: >> Hi >> >> I want to retrieve a row of MySQL data using Perl and DBI, so I do it >> like this: >> >> [code] >> my $sqlquery = qq|SELECT * FROM ata_members WHERE id=$id|; >> $sth = $dbh->prepare($sqlquery); >>

Re: Get hash of MySQL row

2002-02-12 Thread Jeremy Zawodny
On Wed, Feb 06, 2002 at 01:57:21PM +, Wiliam Stephens wrote: > Hi > > I want to retrieve a row of MySQL data using Perl and DBI, so I do it like > this: > > [code] > my $sqlquery = qq|SELECT * FROM ata_members WHERE id=$id|; > $sth = $dbh->prepare($sqlquery); > $s

Re: Get hash of MySQL row

2002-02-06 Thread Jeremy Zawodny
On Wed, Feb 06, 2002 at 01:57:21PM +, Wiliam Stephens wrote: > Hi > > I want to retrieve a row of MySQL data using Perl and DBI, so I do it like > this: > > [code] > my $sqlquery = qq|SELECT * FROM ata_members WHERE id=$id|; > $sth = $dbh->prepare($sqlquery); > $s

Get hash of MySQL row

2002-02-06 Thread Wiliam Stephens
Hi I want to retrieve a row of MySQL data using Perl and DBI, so I do it like this: [code] my $sqlquery = qq|SELECT * FROM ata_members WHERE id=$id|; $sth = $dbh->prepare($sqlquery); $sth->execute or die("Can't execute SQL query. [$DBI::err] $DBI::errstr");