I have started a Multi-player game, and I use MySQL to keep record of in-game information. However, since I recoded the game for a new version, the character table (the table that keeps track of money, stats, hp/mp and other character information) doesn't save. It always reverts back to the original information that was in there before unless you manually change it. Can anyone help?

Are you opening but not committing a transaction?

Transaction :)

When session has been open, exec: SET AUTOCOMMIT=1;