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.

Did you know?Explore Trending and Topic pages for more stories like this.
Any thoughts?
Thanks
No comments posted yet

Your Answer:

Login to answer
295 Like 21 Dislike
Previous forums Next forums
Other forums

How to read posted binary data from a mobile device and post it to a web server?
Here is the senario...

I have a mobile device (MD) that posts binary data to a Web Server (WS

IP Logger for Voting Script
Can anybody help me place an IP logger into my voting script?
I know that maybe it is not as secu

Please Help my PHP Dating Function.
Hi everyone!

Well here is my code that displays this:

It works wonderful.


PHP Include w/If IE Condition Statement?
I was having a problem with Internet Exploder (big surprise, right?) displaying my drop down menus i

PHP Login
Hey!
I got this shopcart code online, am trying to modify it but am getting an error when i try a

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

Coding question?
Hey guys, I have a quick question. If I want to make a way for people to pay for health in my game,

Writing to the middle of a file
Hi I have a bit of a problem. Is there any way i can write some text to a middle of a text file. For

split values
I have values that are returned to me in this format:

name=>test,age=>49

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

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash