MySQL erradict behavior

[ksoong]

Hi everyone i need some help.

i'm programming a database program that updates an announcements table in the mysql database. i want it to insert the new announcement at the end of the table. Sometimes it works fine and sometimes it doesn't. when i delete an entry, things get chaotic and then the entries are inserted at the top of the table or sometimes in between two entries.

is there a way that you can force the mysql table pointer to go to the bottom before you insert?

thanks

 

[DjangMan]

How is your table indexed? You could use an auto increment field as part of a key or as the primary key to maintain the order that the records were entered.

DjangMan