INSERT function

[Lewis Moore]

Hello, i am using the Insert function along with delete to sort news items in a database, i am using PHP to display the news, the first news item to be displayed is the last row in the database, the last news item is the first row in the database.

The problem comes when i delete a record using the delete function. After a row has been deleted this is fine, and the data is still displayed correctly on the news page. How when i use INSERT function again it insert the new item where the last one was deleted.

So if i had three news items, for example

1
2
3

and i delete item 2, and then insert a new item for example 4 is it place where 2 was

1
4
3

I understand why it is doing this, something to do with the table Index!

My question is, can you use the INSERT function to insert data below the last row?! no mader what the table index is???