sorry buddy, as far as I know you can't. The only thing you can do is to set the counter higher but you can't return to a value under the given row.
Please correct me if I am wrong, Andy -- ---------------------------------------------------- http://www.globosapiens.net Global Travellers Network! "Martin Clifford" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED]... Hi all, I have a table that has ARTICLE_ID as the primary key, auto_incremented. I have added three rows to this table, yet I want to delete the third. Here it is now: 1 - Item 1 2 - Item 2 3 - Item 3 My question is, how do I delete Item 3, without having the next row's index becoming 4? 1 - Item 1 2 - Item 2 4 - Item 3 Thanks in advance! Martin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php