Re: Help with table in database and login scripts.

Karl James wrote:

Team, I want to know if my table is setup correctly. I am creating a site where team owners control fantasy football teams. Imaginary teams. They can trade players, add and drop them as long as they are under the salary cap at all times. if not they are given a warning to make a different move or something along those lines. I have created a table for league_members. Can you tell me if I have this set up correctly. This will be for the register.php form Field Type Attributes Null Default Extra Action

   fantasyteamname  varchar(30)   No                     firstname  varchar(20)   No                     lastname  varchar(30)   No                     username  varchar(10)   No                     emailaddress  varchar(50)   No  0                   address  varchar(50)   No                     city   varchar(30)   No                     state  varchar(30)   No                     zipcode  tinyint(5)   No  0                   homephonenumber  tinyint(4)   No  0                   mobilephonenumber  tinyint(4)   No  0                   favoriteprofootballteam  varchar(50)   No  0                   favoritecollegeteam  varchar(50)   No  0               

I'd make fantasyteamname, favoriteprofootballteam, and favoritecollegeteam int's instead and have them as separate database tables. I'm sure many people are going to share the same favourite pro team and college teams so you could make a dropdown box with those options instead of making your users type them in ;) Fantasyteamname should go with the fantasy team details - not be with the user info so keep the team name with the other details, and just an id to link between them. -- Postgresql & php tutorials http://www.designmagick.com/