stock management

i am inserting data into purchase field now i want the stock table ,later when i am sale product from sales table i want to update stock, can u please help me with the database structure and the query? my controller

Database Design and Modeling

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )