There is a table with this structure:
id - AUTO_INCREMENT
name - varchar (UNIQUE)
Adding a new record to the table is performed by code:
mysql_query("INSERT INTO `table` (`name`) values ($name)"); If the same $ name values are encountered, the entry is not added, the order is with this.
But the entries in the table look like this:
ID - name
1 - Igor
3 - Masha
6 - Vita
7 dima
10 - Viktor
That is, ID jumps for some reason ... How to avoid it?
