need some mysql help

ok so i have this table with 142 records... however, once it gets to 127, it just keeps trying to repeat 127 as the record id/primary key... i dont understand why... and of course it wont let me add more records because its a no-repeat field that auto_increments... this makes no sense... why wont mysql count past 127? lol

*screams*

That's easy. The field type is set to tinyint allowing it to go from -127 to 127. You will need to change the field type to something like smallint at least, that will go up to 32,000 something.

Jim

hehe damn i figured that out & was coming back to post...

thanx :)