Gossamer Forum
Home : General : Perl Programming :

Re: [RedRum] $sth->fetchall_array

Quote Reply
Re: [RedRum] $sth->fetchall_array In reply to
Dear RedRum,

I don't know why DBI has only these method to get record from Database.

I think the following codes may help

my $hash_ref={};
while (my $href = $sth->fetchrow_hashref){
$hash_ref->{$href-{'MemberID'}}=$href;
}

The $hash_ref variable now contains all records you want.

Cheers,



Cheers,

Dat

Programming and creating plugins and templates
Blog
Subject Author Views Date
Thread $sth->fetchall_array Paul 11056 Sep 27, 2001, 2:41 PM
Post Re: [RedRum] $sth->fetchall_array
tandat 10904 Sep 27, 2001, 7:48 PM
Thread Re: [RedRum] $sth->fetchall_array
Wil 10965 Sep 28, 2001, 2:11 AM
Post Re: [Wil] $sth->fetchall_array
Paul 10924 Sep 28, 2001, 3:31 AM
Thread Re: [Wil] $sth->fetchall_array
Paul 10896 Sep 28, 2001, 1:48 PM
Post Re: [RedRum] $sth->fetchall_array
Wil 10856 Sep 29, 2001, 6:59 AM