Skip to main content
A
Anonymous
July 20, 2009
Question

Registration Form for walking teams

  • July 20, 2009
  • 1 reply
  • 563 views

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

This topic has been closed for replies.

1 reply

Lawrence_Cramer
Lawrence_Cramer
Inspiring
July 20, 2009

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

A
Anonymous
July 20, 2009

Thank you, I'll give it a try.

Judy Wert

Web and Internet Specialist

Kent ISD

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices