...

View Full Version : auto increments



duniyadnd
10-07-2002, 03:38 AM
I created this table which has a unique column/key which is autoincremented every time a new variable is put in.

I created some pages so that people can post information on the table, but unfortunately, it stops at 127 and says that information is repeated time and time again.

"Duplicate entry '127' for key 1" - is there error that is reported.

So I tried deleting entries and seeing that if it does go beyond 127.

Which led me to my second question as well: If i delete a whole bunch of entries, and want it to start incrementing from the starting point of where the entries are deleted from, how do I do that? So if I had entries from 0-236 but deleted all the entries from 101 to 236, how do I make sure the auto-incrementing command starts from 101 instead?

Thanks
Duniyadnd

duniyadnd
10-07-2002, 03:39 AM
Okay, figured out the first problem, I had the key stored as "tinyint" instead of another form of Int, and I hadn't realized that until I went into my control panel to check it out.

Anyone got any idea on the second problem?

Thanks
Duniyadnd

Spookster
10-07-2002, 07:30 AM
This doesn't belong in the PHP forum. Moving to MySQL forum....

duniyadnd
10-07-2002, 08:24 PM
forget this thread, the following link deals with the same question, sorry for the repeat.

http://www.codingforums.com/showthread.php?s=&threadid=6613

Duniyadnd



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum