PHP: Multiple Repeat Regions from 1 Recordset
Posted on 2009-04-06
I have a simple recordset that simply lists Record ID's and Record Names.
I want to repeat the same rows from the query in 2 or more separate places on the page.
However, if you try to initiate a second Repeat Region, an error is returned as the Recordset has looped through to the last record due to the first Repeat Region.
In ASP i can Requery the original Recordset so the database cursor is reset to the first record again. Maybe not the best practice, but it worked.
What is the best practice to over come this problem in PHP other than having 1 Recordset per Repeat Region?