At 08:11 PM 1/5/2005, you wrote:
Hi list,
How can I traverse the recordset moret than once?
For example, the recordset $sth is returned from executing the sql statement.
The following statement is writen with the "for" loop for retrieving each record from the recordset.
$aref = $sth->fetchrow_arrayref
However when the "for" loop is finished, the pointer of the recordset is point to the end of the recordset. How can I revise the point to the beginning of the recordset ($sth)?
Another thing you might try is to Set
$arefgood = $sth->fetchrow_arrayref
$arefusethisone = $arefgood
Use the $arefusethisone in the for loop. When you want to restart the for loop, just set "$arefusethisone = $arefgood" again. Doing this, you should always have your original. This will probably work in any language you are programming in, but since I don't program in to many languages, I can't give you a definite on that one.
Steve
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
