Data synchronization issue

Hi All,

I m a beginner,I am writing a db layer for mysql,i set mysql_autocommit off in my open_db_connection () API, so that i may support roolback operation.i have written an API which add/get record in data base ... Please have a look at the scenario causing problem ...

I open two console add record in one console and commit it, then if i try to get it in another console, but it shows record does not exists (the record i added in first console and commit) ... Please guide me how should i do it ...

Regards,
Saqlain Abbas