Updating records from a database

[roni]

Hi im not that experienced with mysql or php, but i have a few questions about how the whole AUTO_INCREMENT parameter works, im assuming besides automatically specifying a id, the id also gets automatically updated as well? By this i mean say for instance I delete a record with id=6 then shouldnt all the other row ids reshuffle themselves?

In my case it seems that all the rows have the same id that was initially assigned regardless of the updates.

Any suggestions would be appreciated.

[devinemke]

Originally posted by roni
...for instance I delete a record with id=6 then shouldnt all the other row ids reshuffle themselves?

no. nothing is reshuffled. that would mean total chaos in a relational database system where tables are linked to one another via primary key fields. when you delete a record, that record id is not automatically reused.

[bpat1434]

Auto_increment just adds one to the largest number there. The records will not re-order themselves so they are in sequential order. Also, if you have 10 records, and delete the 10th record, the auto_increment will start with 11 even though the 10th isn't there. Not sure why this is though.

mySQL Auto_Increment Syntax

You could possibly write a function to reshuffle the records by trying to see if there is a value in the row(s) and re-shuffle as you need.

~Brett

Bah!! Devin you beat me to it.

[roni]

cheers guys, well thats cleared a few things, so i guess my problems probably lies with php itself.