handle the stock

To only view quantity of product, Select Productmaster.quantity from Productmaster where productid ='yourproductid' If you know only product name then Select Productmaster.quantity from Productmaster where product='yourproductname'

0

Imran Bashir10y ago

can u plz tell me what was the query

0

Nilesh Sawardekar10y ago

In your project there must be three tables, purchase,sale, productmaster (naming can be anything) then keep one id name common for product in all tables. I often keep ProductID field for product.

After all database task,

In pages, after your product name selection fire a query for stock quantity check and get output from there.

0