mysql table question

wxdqz

New Member
What I want is to have a table that counts the new entries and stays in order even when one is deleted. So if there is 20 added, and I delete number 3, the next one or one of the others would replace it in order. I have it now where if there's 3, and you were to delete number 3 leaving 1 and 2, the next time ones added it would skip 3 and be 4.

here are the properties of the current table.
id tinyint(4) No auto_increment Primary
sender text Yes
message text Yes

If anyone can help, thanks.
 
Back
Top