Hi everybody
Please rectify my doubts.
In my database i have three fields as id,medicinename,quantity.
In medicine name i have many different names.Many names comes twice or thrice.Now i need to fetch the data from database for particular medicine name only(this medicine name comes nearly 10 times)say for example if the medicinename is “A” it comes in id 1,4,9,12,25.Now i want to fetch the data from id 1 only.Whent the quantity comes to “0” in id “1”,i want to fetch the datas from next id.Also when the quantity comes to “0” the row shold be deleted automatically.Please help me to do this.
