Resorting Table

[Anon]

Ok folks, this is my first attempt to get dev-help, and my tech-english isn't as perfect as I'd want it to be. I also search several PHP and SQL-faqs, but as I said, my poor technical english skills don't get me anywhere. Anyway, please don't let me down! ;-)

I have a table with some >20 columns, which of one is holding an ID (auto_increment) and is called "EID" and another one holding the unixtime which is called "SEC2". I use both of these fields to sort, but I implemented an option in my PHP-scripts to modify SEC2. Problem is that when I do that EID and SEC2 don't match anymore.

I hope you understand what I'm trying to say here - is there a possibility to re-sort the table on SEC2 while updated the auto incremented EID?

By the way, I'm using the latest stable version of MySQL with phpMyAdmin both locally as on my server, if that's important. I'm obviously not an SQL-expert, so a plain and short answer could help me a lot!

Thanks in advance!

[[deleted]]

The auto_increment column is not designed for sorting. It is designed to automatically generate numbers that you can use identify records.
If you need to re-order (re-sort) something, use a new column especially for ordering.

Never ever change the numbers in an auto_increment column.

[Anon]

Thanks. Will keep that in mind.