I've got a project where I've got 5 groups of golfers... and I need folks to
be able to choose up to 2 golfers per group... no more, no less.
Anybody have any advice on how best to do this?
This is what I have so far:
<form name="team_info" action="" method="post">
<!--- Select all golfers from group 1. --->
<cfquery name="golfers1" datasource="#DSN#" username="#db_username#"
password="#db_password#">
SELECT *
FROM gp_golfers
WHERE golfer_group = 1
ORDER BY
golfer_name, golfer_initial
</cfquery>
<b>Group 1</b>
<br />
<cfloop query="golfers1">
<input type="checkbox">#golfer_initial# #golfer_name#<br />
</cfloop>
</td>
<td>
<!--- Select all golfers from group 2. --->
<cfquery name="golfers2" datasource="#DSN#" username="#db_username#"
password="#db_password#">
SELECT *
FROM gp_golfers
WHERE golfer_group = 2
ORDER BY
golfer_name, golfer_initial
</cfquery>
<b>Group 2</b>
<br />
<cfloop query="golfers2">
<input type="checkbox">#golfer_initial# #golfer_name#<br />
</cfloop>
</td>
<td>
<!--- Select all golfers from group 3. --->
<cfquery name="golfers3" datasource="#DSN#" username="#db_username#"
password="#db_password#">
SELECT *
FROM gp_golfers
WHERE golfer_group = 3
ORDER BY
golfer_name, golfer_initial
</cfquery>
<b>Group 3</b>
<br />
<cfloop query="golfers3">
<input type="checkbox">#golfer_initial# #golfer_name#<br />
</cfloop>
</td>
<td>
<!--- Select all golfers from group 4. --->
<cfquery name="golfers4" datasource="#DSN#" username="#db_username#"
password="#db_password#">
SELECT *
FROM gp_golfers
WHERE golfer_group = 4
ORDER BY
golfer_name, golfer_initial
</cfquery>
<b>Group 4</b>
<br />
<cfloop query="golfers4">
<input type="checkbox">#golfer_initial# #golfer_name#<br />
</cfloop>
</td>
<td>
<!--- Select all golfers from group 5. --->
<cfquery name="golfers5" datasource="#DSN#" username="#db_username#"
password="#db_password#">
SELECT *
FROM gp_golfers
WHERE golfer_group = 5
ORDER BY
golfer_name, golfer_initial
</cfquery>
<b>Group 5</b>
<br />
<cfloop query="golfers5">
<input type="checkbox">#golfer_initial# #golfer_name#<br />
</cfloop>
</td>
</tr>
</table>
<input type="submit" value="Save Changes">
</form>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
