LApprenti Sorcier

Oddly, i\'ve been convince by your last argument... LOL Thanks anyway.

I don\'t quite know where to start, but here it goes... I have a table, in which the first column, let\'s call it, ID, is an int(5) type field, is the primary key, and is set to auto_increment. I will be adding and adding rows... But at some point, old rows will be deleted... Now, I have two (may be 3) questions: If I delete an older row, and I add a new one, will this new one have the ID number of the older one, thus taking up it\'s place? I don\'t think so, so here comes the \"may be 3rd\" question: So how do I get it to reuse that ID number and that space? And the 2nd question (Odd ordering nah?): What happens when it get to ID number: 99999? I mean, its int (5), right? is that 5 digits?, then, what will it do? add another one? or reuse the first ones? maybe, cause an error? So if anyone can answer that, great!, or someone could also summarize everything and tell me this: How do I keep reusing \"unique_id-ed, auto incremented\" rows from 00000 to 99999 after (notice this) deleting them in no particular order, and always assigning them a number automatically? Thanks all!