Commits the current transaction for the specified database connection. Returns zero on success, nonzero if an error occurred.
Executing mysql_commit() will not affected the behaviour of autocommit. This means, any update or insert statements following mysql_commit() will be rolled back when the connection gets closed.