RE: fetchrow_hashref

[Sterin, Ilya]

execute() again.

Ilya Sterin

-----Original Message-----
From: Jonas Ask�s
To: dbi-users
Sent: 05/14/2001 2:40 PM
Subject: fetchrow_hashref

Hi,

Sorry to bother you with an (maybe) easy question, but I don't now how
to
do...

I want to to this:

$SQL = "SELECT * FROM members";
my $sth = $dbh->prepare($SQL);
$sth->execute;
my $record_hash;

while ($record_hash = $sth->fetchrow_hashref){
   print "$record_hash->{first_name} $record_hash->{last_name}\n";
}

Then I want to search the "$sth" again, and maybe print some other
information, like this:

while ($record_hash = $sth->fetchrow_hashref){
   print "$record_hash->{last_name} $record_hash->{company}
$record_hash->{e-mail}\n";
}


My question is:
After I've search $sth the first time using the fetchrow_hashref-method,
how
do I point $sth to the first position in the array again, so I can
serach it
again?

Regards,
Jonas Ask�s