Re: Re: May i?

well....... yes, then maybe i made a mistake.... there was data related to the id ..... then i delete that row.... and the data that was related to the comments are gone away, because the row id has changed....so i would have to put then manually again.... Flavio Bastos Amiel "Maxim Maletsky" <subscriptions@phpbeginner.com> wrote in message news:000c01c23b50$050fcfe0$1113fe17@dominanta... > > 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:flavinho@cantv.net] > > Sent: Wednesday, September 04, 2002 2:28 AM > > To: php-general@lists.php.net > > 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" <geomasterweb@hotmail.com> wrote in message > > news:20020804001037.31489.qmail@pb1.pair.com... > > > ask. > > > > > > -- > > > > > > > > > Best regards, > > > George Nicolae > > > IT Manager > > > ___________________ > > > PaginiWeb.com - Professional Web Design > > > www.PaginiWeb.com > > > > > > > > > "::: Flavio Bastos Amiel::::::>" <flavinho@cantv.net> wrote in > message > > > news:20020803224811.95593.qmail@pb1.pair.com... > > > > 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 > >