[aoEXE]

Hey Guys, I would want know if it's possible with a mysql sentence:

Example:

Код:

ID    |     Name

1           Petra
4           Custodio

How would can find missing number between 1 and 4?

That is to say 2, then 3, and then returns 5?

[Vince]

Use auto increment.

[GangstaSunny]

Quote:

Originally Posted by Vince Use auto increment.

This wont return the free id.
I think this should help you > http://stackoverflow.com/questions/5...e-id-available

[PrO.GameR]

Simply look for the lowest ones that doesn't exist ? doesn't matter if 4 is there, just see if 2 exists, if not return 2;