PHP - Repeat Region question

The explanation of what you're trying to do is not at all clear. However, the code you have posted here will produce a mess.

Basically, a repeat region is a do... while loop. What it does is loop through the database results until they have all been used. Consequently, nesting two loops, as you have done, will produce the following effect:

• The first time through the getEven recordset, the table headers and the first five fields will be displayed.
• Then the getCountp recordset kicks in, and creates a table cell in the second row for every result in the recordset. If there are 10 results, it will add 10 cells after the first five.
• After the getCountp repeat region has finished, the final field in the second row is populated, the table and form are closed, and an image is displayed.
• The getEven recordset then goes into the second iteration of the loop, displaying the table headers again, plus the first five fields in the second row.
• When it gets to the getCountp repeat region, there's nothing left in the getCountp recordset to display because you already looped through it the first time. So it's ignored.
• The final field in the second row is displayed, but the row will be one cell short, because the getCountp field had nothing to display.
• The getEven recordset will continue the same way until it reaches the end.

If you want to display a value in each row, you will need to create a SQL query that joins the two tables, and use a single repeat region to loop through the results.