Results 1 to 8 of 8
Thread: Balance quantity update
Apr 3, 2011, 23:32 #1
- Join Date
- Aug 2010
- Nagpur, India
- 0 Post(s)
- 0 Thread(s)
Balance quantity update
I have two interrelated tables,purchase_order & purchase_order_data.
purchase_order table contains info like supplier name,po no,gr_status etc, whereas purchase_order_data table contains values that are inserted through dynamic text fields, like qty, price etc.
I want to run the following query so as to make gr_status=1 if all the quantities in dynamic rows are received in goods received note.
$gr_status=mysql_query("UPDATE purchase_order SET gr_status=1 WHERE po_no='".$po_no."'");
Can anyone guide me how to check that all the quantities with the purchase order are received or not??
I hope I sound clearIt's easy once you know how...