It fetches one row and returns an array, to fetch the next row you just call
this method again
so you will have something like
while (my (@row) = $sth->fetchrow_array()) {
# do something with @row;
}
array reference is a reference to an array, not an array just a reference.
check perl documentation on references.
Anton
-----Original Message-----
From: Mat Harrison [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 25, 2002 12:34 PM
To: [EMAIL PROTECTED]
Subject: retrieving lots of rows
I know about using
@results = $sth->fetchrow_array();
but that only gets one row. I have read about fetchall_arrayref but what
does this do, how do i use it and what is an array reference?
--
Matthew Harrison
Webmaster
www.genestate.com
[EMAIL PROTECTED]
