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

Parse error: parse error in C:wampwwwlogspagesmembers.php on line 16
I dont see the problem with this, I always get Parse error: parse error in C:wampwwwlogspagesme

date("now") prints out wrong date ?
Hi Guys
Anyone know why and how I can fix it ?

How to display random record from table?
I have the following code:

Code: <?php
$display_block .= "<input type=

PHP url branch??
Functionally, using PHP, I'm doing a test of login input submitted by a user via an html form in a f

Where do I put CRON code
So I've figured out alot about how to automatically run a php function. I can't figure out where to

How to schedule the a job?
Hi,
I have prepared a task ( i.e. a procedure is prepare the file and send the same to con

Hyperlink is adding an extra gap to variable
Hi, here's my problem..

I have a php generated page with a hyperlink which opens in a new win

Need a Timecode Class...
Not a Time Stamp, Time Code. Format is a bit different. HH:MM:SS:FF where FF is Frames. I dont re

natcasesort works on one server but not on another
Hi

I have a problem that I was hoping that someone can help me with.

I'm trying to use

Linux socket programming
Where can I find a good introduction to socket programming?