Why do you need it anyway?
auto_increment is a mySQL functionality to (listen this carefully) KEEP UNICITY WITHIN A TABLE. This is what they are needed for. I agree - it would look prettier having them even sequential, but that is behind the real point and it is not a "problem". You should make your application independent from "id" value - "id" should only serve you as a key to relate the data within application/database. Sincerely, Maxim Maletsky PHP Beginner www.phpbeginner.com > -----Original Message----- > From: ::: Flavio Bastos Amiel::::::> [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 04, 2002 2:28 AM > To: [EMAIL PROTECTED] > Subject: [PHP] Re: May i? > > let's see if i can do it... > > i got a news site..... everything was going OK....sometimes i made few > testing and then i delete the content from the db... the problem is next: > > the item "id" is an auto_increment element .. so the id's wasn't going > allright....because they where not true... sometimes they make jumps like > id > #25 and the id #30 (because of the testing i've done and then delete) > > i tried to delete that cell (id) and then i recreate it. thinking the id > was > going to count it all over and make the item id TRUE.....but it wasn't > like > that, the "new" id was counting since the last id then if the last id was > 100, the new id was counting from 100 to 200 .... do i explain myself?... > does anyone have an answer to this problem (PLEASE Dont tell me i have to > do > i manually!! ) > > thanks, > Flavio Bastos Amiel > > > > > > "George Nicolae" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > ask. > > > > -- > > > > > > Best regards, > > George Nicolae > > IT Manager > > ___________________ > > PaginiWeb.com - Professional Web Design > > www.PaginiWeb.com > > > > > > "::: Flavio Bastos Amiel::::::>" <[EMAIL PROTECTED]> wrote in message > > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > > May i ask for help about a subejct on MySQL here? > > > > > > thanks, > > > Flavio Bastos Amiel > > > > > > > > > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
