Create new Table - Newbie

Chimp8471 · #1 (**permalink**) 06-21-06, 06:38

I want to store some data in a MYSQL table for my football club, but am not sure which field types to set the table up with.

Can anyone offer me some advice please

Field Names:

PlayerID - Autonumber
Forename
Surname
DOB
RegNo
Photo (image to be stored on my webserver, so this would be a link to that photo's Path)
Nickname
Comments

Thanks in advance

Andy

r937 · #2 (**permalink**) 06-21-06, 06:59

Code:

create table Players
( PlayerID  integer     not null primary key auto_increment
, Forename  varchar(50) 
, Surname   varchar(50) not null
, DOB       date
, RegNo     tinyint
, Photo     varchar(255)
, Nickname  varchar(50)
, Comments  varchar(255)
);

Chimp8471 · #3 (**permalink**) 06-21-06, 07:02

many thanks for that, i just need to work out how to get the php code to read from it now

thanks

Andy

Chimp8471 · #4 (**permalink**) 06-21-06, 17:46

am i right in thinking that should i want to add a few new fields to this the code should be:

create table Players
( PlayerID integer not null primary key auto_increment
, Forename varchar(50)
, Surname varchar(50) not null
, DOB date
, RegNo tinyint
, Photo varchar(255)
, Nickname varchar(50)
, Comments varchar(255)
, Position varchar(50)
, GamesPlayed tinyint
, GoalsScored tinyint
);

The new fields being

, Position varchar(50)
, GamesPlayed tinyint
, GoalsScored tinyint

also when i insert a new record via a form do i have to include the PlayerID field or just start from the Forename field? i think the PlayerID number is created automatically

please advise!!