Quote:
|
YOU MUST START YOUR USER_IDS FROM: '08053118000306' THEN ADD ONE FOR EVERY USER.. DONT ASK WHY I DONT KNOW!
|
Maybe I know why... it could've been this:
maybe the field is set to: automaticnummering and it has a primary key
which means the ID will keep nummering from 00000000000001 to *** knows where.... And it will keep nummering that way even though you delete them. For example:
User ID:______Name of someone:_____Product:
1____________John________________Dildo
2____________Eric_________________Condom
3____________Angela_______________Vibrator
whenever you remove Angela from the database the user ID will be keep nummering... Which means your new user will be:
User ID:______Name of someone:_____Product:
1____________John________________Dildo
2____________Eric_________________Condom
4____________Picolo_______________A bag of chips
*I cant use spaces so I'm using the _ instead if you dont mind
*
How to fix it: recreate the table lol
First remove the whole table and then recreate it in some kind of database program...
After that do exactly the same as the makers of the database did...
Create a autonummering column with a primary key and create all the other columns like the original creators of the database did...
(I know this because I had to make some databases for school
... Eather ways... If you want to solve that problem you will be having to do it the hard way :S)
