duniyadnd
10-07-2002, 02: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
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