Looking for some php help..

[imported_Jamie]

Okay, I just recently started my own project for my rap site.. its an Artist database, and i have all the info showing via functions.. Now, what im having problems with is, when i add an artist, its fine. but when i delete that artist, and add another, the userid's get bigger.. example:

uid=1 - delete that and add another:
uid=2 - thats what the second userid starts add... if i had 500 userids, then the userid would start at 501.. Its making me mad, and i aint sure how to fix this

[SaintDog]

If you are auto-incrementing the ID's through keys then it will raise with each addition, when you delete a row, then MySQL picks up where you last left off, which would be the ID after the one you deleted or the next one in line.

[filburt1]

This is by design, BTW, to stop freaky things from happening. It's an INT(10) so you won't have to worry about anything unless the column eventually gets a value of 10 billion.