DBI - move to start of record-set?

[Gooner]

I am trying to pick up records from a mySQL database. It works fine unless there is just one record, it will not do anything. I think I need a jump 'Begining of File' command (if it exists!) as my original 'fetchrow_hashref' moves onto the only record, can anyone help please?
------------------------------------------------------------
if(my $ref = $sth->fetchrow_hashref())
{
open(TEXTFILE, ">$username.txt"
while(my $ref = $sth->fetchrow_hashref())
{
print TEXTFILE "$ref->{'record'}";
print TEXTFILE "$ref->{'reference'}";
}
close(TEXTFILE);
}
else
{
print "No entries in DB";
}
------------------------------------------------------------
Thanks for your time and trouble.

 

[Gooner]

I have sorted this now.

 

[MikeLacey]

Hi Gooner - how did you solve your problem? Mike
michael.j.lacey@ntlworld.com
Email welcome if you're in a hurry or something -- but post in tek-tips as well please, and I will post my reply here as well.