transaction

[João Cândido de Souza Neto]

I've getting something wrong in transaction in Mysql 5.0.22 on windows that 
i don't know way it's happen.

I've got a script in php which starts a transaction and when if fails and 
rollbacks, the autoincrement do not back.

e.g.

If in transaction some field auto increment gets the value 4 and this 
transaction fails, in the next transaction it gets the value 5.

Is it right?