RE: [PHP] mysql problems, need help quick

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 table, recreate it, and import the contents into the new table. I'd also suggest, if these numbers have to be sequential, that you look hard at your db design to see if this is the right column to use as a PK. Incidentally, this is a PHP list. If you need to ask MySQL questions, please join one of the lists at http://mysql.com/. Cheers Jon