ticallian
asked on
PHP: Multiple Repeat Regions from 1 Recordset
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?
Thanks
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?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I had already tried that but must have had a typo as it failed.
Tried again and it worked fine.