Registration Form for walking teams

[Guest]

I am working on a site for our employees to join walking teams. I am using php amd MySQL. I have the registration form working, but I need to refine it.I have the email address as a unique field. How can I make the "Team Names" also unique based on location.

http://ht.kentisd.org/oregon_trail/Templates/captains_RegistrationTest.php

[Lawrence_Cramer]

The way I would do it is create a teams table in the database, then create a location table that could record cities, then you could create a relationship for the teams to the location record. This way you can have a number of teams in a given location if need be. Finally when you add a user you would create a relationship for the user to a team.  Doing this you can filter users based on teams or locations, or pull up all users.  This would give you a pretty flexible system.

Hope this helps.

--
Lawrence   *Adobe Community Expert*
www.Cartweaver.com
Complete Shopping Cart Application for
Dreamweaver, available in ASP, PHP and CF
www.twitter.com/LawrenceCramer

[Guest]

Thank you, I'll give it a try.

Judy Wert

Web and Internet Specialist

Kent ISD