[SOLVED] auto-inc not working?

[Ninjakreborn]

I don't see a problem with it.  My client is claiming that he has auto-inc fields that are not working right.  He says they auto inc properly, but if he deletes one, and adds another one, it doesn't make note of the missing numbers.

 

For example.

 

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15 - Whoops, here he deletes 15

entered another new one

15

16

17

instead it was suppose to be from that point to go

16 17 18

See what I mean.  It's basically the way he explained it, when they delete one, and add a new one, it replaces the number that was just deleted.  This is against the inherent nature of auto-inc, either he is misunderstanding the way it operates, or something is wrong with mysql.  Is this suppose to happen, or is it his imagination.