reorder an sql table

[cashton2k]

i have an sql table with an auto incrementing id field, they may site works is that it needs the numbers to be consecutive and if an entry is deleted it will break this. is there an sql/php way to reorder the numbers to be consecutive again?

e.g. 1,2,3,4,5,6,7,8,9,10

4,5 deleted

1,2,3,4,5,6,7,8

cheers for any help

[chazzy]

Why would you need to do that? Can you explain the logic that says you need to have consecutive numbers, as that's not how it should be with any application.