Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 693
  • Last Modified:

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
 
0
ticallian
Asked:
ticallian
1 Solution
 
hernst42Commented:
Have you looked at http://www.php.net/manual/en/function.mysql-data-seek.php So the second time you want to process the record set use
mysql_data_seek($result, 0);
and then restart you fetches.
0
 
ticallianAuthor Commented:
Thanks.
I had already tried that but must have had a typo as it failed.
Tried again and it worked fine.
 
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now