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