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

Reply via email to