not on auto increment...thats the point! why would you need to get the #6 back anyway...
this is the fundementals of database theory... chances are the database is using this autoincrement field as the PRIMARY KEY...in which case no duplicates are allowed.. In terms of records...your id#7 has become record #6. I can't think of any reason why loosing the #6 should affect anything you want to do. XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXx "Hawk" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I'm filling a database with info, and I'm using id as identifiers in the > list, the id is auto increment, and I deleted one entry, now I have a hole > in the database, is there any way to fix this? > lets say I have > 1 > 2 > 3 > 4 > 5 > 6 > And I deleted 6 > Now it looks like > 1 > 2 > 3 > 4 > 5 > 7 > 8 > 9 and so on > > is there somewhere the "next" number is located ? > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
