MySQL Primary key gap

Posted on 16th Feb 2014 07:03 pm by admin

Alright, so I have a table with 26 entries in it (id, filename, caption) for my image randomiser (http://zeroerror.co.uk/community_img.php) which is working fine, technically, but I have a slight problem.
The primary key (id) is set to AUTO_INCREMENT and I have recently deleted a row, so it counts 1, 2, 3, 4, 5, 6, 8, 9, etc.
I'd like to know the easiest method of fixing this, which I can build into the deletion script I have written for the administration panel.

Any thoughts?
Thanks

Your Answer:

Login to answer

Other forums

Simple MySQL query...
Hello,
How could I do a mysql query that does this: SELECT * WHERE date/time < 5minutes ag

Echo-ing MySQL content and Keep Formatting?
I have data in my MySQL such as:

QuoteBlah blah

Blah blah

etc
but when i ech

convert static html data into dynamic
hi all

i need to convert a website which has static above 2000 articles into dynamic and add

Accessing element of object array
Hello

My object looks like this:


Array ( [0] => User Object ( [id] =>

Table trouble
i have been reading the forum for a few weeks and decided to join. i like the format and the advice

Upload, SSL and more php help
I recently just installed a ssl cert and do i use https for the whole site or just for the checkout.

Log $_POST
How would i log submits on a form, by everyone? I want to then echo the number of submissions.

PHP - HTML
Could anyone give me some GOOD sample links for php - html email tutorial.

Thanks!

quick question about System Change Number(SCN) in FlashBack Query topic
i know tht we can get the SCN of the database using flashback concept as follows

SQL>

passing an array of objects after submit
How do I do this? This is what I have tried and it is not working.

<form method="