Duplicate entry to MySQL

[lulubell]

I am having trouble when I try to insert an entry into a MySQL database, both when using PHP and the MySQLFront program.

When I have entered 127 entries, and I try to insert another entry, I get the result:

Duplicate entry '127' for key 1

Meaning that by inserting the new entry there will be a duplicate entry in the Id field. The field that it is having a problem with has been created as:

id tinyint(4) NOT NULL auto_increment

I have tried recreating the database, but everytime I get to insert entry 128 I get the error message.

Any suggestions?

[Lars_Berg]

Change the data type to integer. The maximum value for a tinyint is 127

[lulubell]

Hi

Thanks very muchly for the advice, of course it worked, I feel like such a fool, but I've not been doing this long.

Cheers