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

System copy error in RUN ABAP REPORT PHASE
Hi,
I am performing system copy on my test server. I have previously taken export of JAVA + A

Help with lottery style system?
I'm working on a currency system for forums and it is going to have a type of lottery system built i

Advice on how to delete a mysql row using my form
Hi,

I am very new to php and am struggling to work out how to delete a portfolio item (a row

parsing error
can anyone explain this syntax error:

Parse error: syntax error, unexpected T_IF

The e

Function
How can I make this function that once you click the link in the code it takes you to a new page wit

A href problem under php
Hello...

I tried to explain the issue in an earlier post.. but was not clear enough....

OPINIONS WANTED
This is my login page code, and I want your opinion on it please!

Code: // Login ~ CHECKS

Access website from only 1 computer...?
One of my customers wants his website to only be accessed by people in which they bought the website

Mysterious Timeouts
I've deployed a few simple AJAX-enabled web page to a local server that is accessed through the Inte

Login Issue's
Code: <?php
$file = fopen('user.txt', 'r');

/* Set login to false initially */