Pulling data one row at a time?

I have a MIGx table with the Date and Prices of a Theater Show:
Date GeneralAdmission SeniorAdmission YouthAdmission
Date GeneralAdmission SeniorAdmission YouthAdmission
Date GeneralAdmission SeniorAdmission YouthAdmission

And I have a Chunk with a <select> drop-down containing the getImageList call pointing to my shows.tpl.

The shows.tpl is just a group of <option> tags with the price info:
<option value="[[+GeneralAdmission]]">General Admission</option>
<option value="[[+SeniorAdmission]]">Senior Admission</option>
<option value="[[+YouthAdmission]]">Youth Admission</option>

This method works great if I only have one row in my MIGx table, but with more than one row it's pulling the Admission info from every row and spitting out a <select> like:
<select>
<option value="[[+GeneralAdmission]]">General Admission</option>
<option value="[[+SeniorAdmission]]">Senior Admission</option>
<option value="[[+YouthAdmission]]">Youth Admission</option>

<option value="[[+GeneralAdmission]]">General Admission</option>
<option value="[[+SeniorAdmission]]">Senior Admission</option>
<option value="[[+YouthAdmission]]">Youth Admission</option>

<option value="[[+GeneralAdmission]]">General Admission</option>
<option value="[[+SeniorAdmission]]">Senior Admission</option>
<option value="[[+YouthAdmission]]">Youth Admission</option>
</select>

When I really just want one row pulled at a time:

Show #1: Date
and the prices for that show (row 1)
<select>
<option value="[[+GeneralAdmission]]">General Admission</option>
<option value="[[+SeniorAdmission]]">Senior Admission</option>
<option value="[[+YouthAdmission]]">Youth Admission</option>
</select>

Show #2: Date
and the prices for that show (row 2)
<select>
<option value="[[+GeneralAdmission]]">General Admission</option>
<option value="[[+SeniorAdmission]]">Senior Admission</option>
<option value="[[+YouthAdmission]]">Youth Admission</option>
</select>

Does that make sense? Any tips would be appreciated! Thank you.

can't you just put this whole thing into your shows.tpl?

Quote from: Bruno17 at Jan 22, 2014, 08:31 AM

can't you just put this whole thing into your shows.tpl?

<select>
<option value="[[+GeneralAdmission]]">General Admission</option>
<option value="[[+SeniorAdmission]]">Senior Admission</option>
<option value="[[+YouthAdmission]]">Youth Admission</option>
</select>

Here is what I'm trying to output (this is what happens with the <select> in my .tpl


I'd like the ones with red lines to not be there.

This is my Table

Figured it out! I needed to do just the opposite of what you said. I had to bring the <options> to the <select>

Solved!