I created a webpage that adds the following info in my database: ID and Name.I don't know how to explain exactly what I want to do but here it is.I set ID as Primary and check the auto increment for it.

I fill up the form containing Name in my webpage and let PHP handle it and do it three times with different values. The ID will be input automatically by auto incrementation.

Then I view it in PHPmyAdmin

1 Martin
2 Matthew
3 Michael

As you can see the autoincrementation handles the ID and in sequence. Now I delete the row with ID #2 so that leaves the row with ID # 1 and 3. Then I went back to my webpage to fill up again.Now here is my problem when I view it in the PHPmyAdmin

1 Martin
3 Michael
4 Matthew

How can I fix this? I want the new data to be inserted into gaps. Thanks

You can't, auto increment increments from the last value, you would have to determine the ID value and fill the gaps yourself and write it to database, without using auto increment. Are you trying to determine how many records are in the database? for that, use "count" operator.

Why do you want to 'fill the gaps'? If you need a sequential numbering system for human reference - then add one to your table and alter your scripts to check for 'gaps' and insert with an appropriate number value. However leave the ID alone; this is used for a database reference to a unique record in a table, more important than human reference.