if you look at this:
http://www.chimp.cc/Players/
you will see that all the reg no's are 127,
I have changed these a number of times but they keep going back to 127..
i have no idea what is going on
current set up
Code:
CREATE TABLE `players` (
`PlayerID` int(11) NOT NULL auto_increment,
`Forename` varchar(50) default NULL,
`Surname` varchar(50) NOT NULL default '',
`DOB` date default NULL,
`RegNo` tinyint(4) default NULL,
`Photo` varchar(255) default NULL,
`Nickname` varchar(50) default NULL,
`Comments` varchar(255) default NULL,
`Position` varchar(50) default NULL,
`GamesPlayed` tinyint(4) default NULL,
`GoalsScored` tinyint(4) default NULL,
PRIMARY KEY (`PlayerID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
please help