Skip to main content
Participant
March 4, 2008
Question

ASP loop or repeat help

  • March 4, 2008
  • 1 reply
  • 367 views
Hello everyone,

I have a simple database that has two tables.
One is Membership:
Just three fields: MemberShip ID (primary key) , Membership name and Membership Price.
The second table is Benefits.
Just two fields: Benefit ID (join with Membership ID) and Benefit name.

Here's a simple example:

Membership Table:
MemID | Name | Price
1 Individual $50.00
2 Family $200.00

The benefits table looks like this:
Ben ID | Description
1 Pool Pass
1 Park Pass
2 Pool Pass
2 Park Pass
2 Gate Pass


So, the Individual Membership costs $50.00 and includes a Pool Pass and a Park Pass
The Family Membership is $200.00 and includes a Pool Pass, Park Pass and Gate Pass.

I would like to display:

<h3>Individual Membership</h3>

(unordered list)
-Pool Pass
-Park Pass

Price: $50.00

A submit button.

Then, repeat for the next membership:

<h3>Family Mamebrship</h3>

(unordered list)
-Pool Pass
-Park Pass
-Gate Pass

Price: $200.00

Submit Button


This area would continue to repeat through all benefits.

Can anyone suggest a link or some information to point me in the right direction?

I can make the recordset, know how to display dynamic text and repeat region but am not sure how to repeat this area of information.

Thank you for your time,

Tim
This topic has been closed for replies.

1 reply

Inspiring
March 4, 2008

"TC2112" <webforumsuser@macromedia.com> wrote in message
news:fqi52u$5j1$1@forums.macromedia.com...
> Hello everyone,
> Can anyone suggest a link or some information to point me in the right
> direction?

go to http://www.tom-muck.com/ and search for his Simulated Nested Region
extension.


TC2112Author
Participant
March 5, 2008
Hi Hunter,

Thanks for taking a look. I actually have that extension and it would work well for:

Individual Membership
- pool
- park

Family Membership
- pool
- park
- gate

It's getting the submit button and the price listed after the repeating list that's driving me crazy :-)

Take care,
Tim