Multiple Repeat Regions create Selection error

Hi there
I'm new to WA products so please bear with me. I have an admin page created in Dreamweaver CS4 in which I'm using DataAssist Repeat Selections.

One part of the page is a submission form which contains a repeat selection comprising of a standard form drop down menu (named 'driver_id') which is dynamically populated and a couple of text entry fields. I've then applied an Insert Multiple Records behaviour to this repeat selection (creating 6 versions of this selection) and it all works beautifully.

The problem occurs when I add a second repeat selection elsewhere on the page to display a dynamically populated list. For some reason, when I do this, the first of the dynamically populated drop down menus in the form mentioned above loses its content. The other five duplicates of the drop down are populated fine, but the first one is empty.

I've looked through the forum and found something fairly similar which mentioned displaying a hidden field like...
<input type="hidden" name="driver_id_hidden_<?php echo $RepeatSelectionCounter_1; ?>" value="1" />... directly after the field which is the problem, but in the same cell,
and then replacing "driver_id" in the WA_loopedFields with "driver_id_hidden". I tried this, but unfortunately it didn't resolve the issue.

I would be grateful for any assistance.
Kind regards
Paul

UPDATE:

Hi again, I've almost resolved this but have one final problem. To make it easier I'll explain here just the new situation...
I have a Repeat Selection which contains a dynamically populated drop down menu and a couple of text entry fields. The repeating is set to six so in essence I have 6 copies of the drop down menu. The problem I have is that only the first version of the drop down menu displays all of the correct dynamically populated values (1-5). The other five duplicates list all apart from the FIRST dynamic value (displaying 2-5).
I would be grateful for any assistance with this?

Kind regards
Paul

You say that:

The other five duplicates list all apart from the FIRST dynamic value (displaying 2-5).

So you are getting the same listing in each of the other select lists? Are these repeat selections based off of the same recordset? Please post back with this info and also include a copy of the page in question so that we can take a look at it.

Hi Eric, thank you for getting back to me.

Please find attached a copy of the file. Essentially, all 6 copies of the drop down run from the same recordset as I only hand coded one and set a repeat selection around it. The area in question is towards the bottom of the page headed 'Submit Driver Results'.

Many thanks in advance.
Paul

Thanks for the info and the page. I can see what is happening, the problem is that the repeat selection makes use of the mysql_fetch_assoc after each iteration. By the time it gets to this code the recordset has already been updated to point at the first record. When this code is executed the recordset pointer is updated again to point to the next record.

To resolve this problem you will need to find the fetch assoc call for the repeat selection and comment it out or delete it. This should be on line 414 of the file you posted:

//$row_driversresults = mysql_fetch_assoc($driversresults);

This should get it working correctly for you. This is only a problem because you are using the same recordset to populate the list and set the repeat selection. If they were different you would not have this problem.

Hi Eric

That's worked perfectly, many thanks for the assistance.

Kind regards
Paul

Glad to hear it, thanks for posting back to let us know it worked.