[PHP] mysql problems, need help quick

2002-06-11 Thread Hawk
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

RE: [PHP] mysql problems, need help quick

2002-06-11 Thread Jon Haworth
Hi Hawk, (snip auto-incrementing PKs) is there somewhere the next number is located ? No. Why would you care, anyway? The thing about PKs is that they have to be unique, not sequential. If you're *really* bothered by it, you'll have to dump the contents of the table to a file, drop the