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

Other php-forum

Staff Induction System - No idea where to go from here!!!
Hi there, I'm pretty new to PHP and Mysql so could really do with being pointed in the right directi

Php - mysql store data and use it later?
Hi, i' making a login page at the moment, however my username + password is stored many different pl

Multi Level Array Problem
hi all,

For example I have array like below:

$temp = array(array('north america', 'us'

pageination not working right... coping images over 4 pages
Code: <?php //This code will obtain the required page number from the $_GET array. Note that

Polymorphism
Was wondering if someone could explain this a little better to me. I had always assumed that it had

PHP hyperlinks generator - HELP plz
Hi

I need some help to get this done using php:


1 - I have few hyperlinks say 500

Dealing with code in db query
I am dealing with C code and I need to make sure it is encoded some how to ensure its integrity and

array ...
hi
Code: function formatCategories($categories, $parentId)
{
// $navCat stores all child

Search in the PHP Files
have to search asterisk(*) in the php code of the php files .
In the html page one text box

Displaying data from MySql a different way
Hi all,
I'm pretty new to php and MySql and have hit a problem.

I am able to display data