What you want to do is add a column that can be used to sort the rows in the table. For example, ... really recommend is MySQL by New Riders. I believe the author's last name is Dubois.

You can set where auto-increment starts. I believe it works in MySQL 4.1; I don't see why it wouldn't (but I hope you have a really good reason for sticking to 4.1).<BR><BR>ALTER TABLE tablename ...