ZoomCities IT Community Webmaster Forum

Is there a way to resort things in a database?

EG:

Say you got 15 entrys in a database but you delete 3 then you have a gap between 9 - 12 Well how can you get it back to 1 - 12?

So basicly reorder ID's

Well theres the ORDER BY 'blah', but I think what you need is for it to detect how many you delete and what numbers you delete, then update the ones above it.

Carnt it be done some were im phpMyAdmin?

Hell if I know....you might have to setup a php script that deals with it custom made.