Member Avatar for Sikander Nasar 
/*


    -------------Physical Quantities------------Available Quantities
    *             51                               50
    *             51                               50
    *             63                               62
    *
    *   **********************************************************



this is my table which confusing me too much.Error in this code is that when an order is processed it will add 1 to all the physical quantities,this product have four colours and i have selected only one color.at above i have 50 physical quantities but it add 1 to all the orders.how can i do this that it can only change 1 order by its color.
1:the first line of code is from my inventory.php
2:the 2nd code id from get_inventory.php
*/





 <td><?= ($iQuantity + getDbValue("SUM(quantity)", "tbl_order_details", "product_id='$iId' AND order_id IN (SELECT id FROM tbl_orders WHERE FIND_IN_SET(shippment_status, 'P,C,R'))")) ?></td>


    @utf8_encode($iQuantity - getDbValue("SUM(quantity)", "tbl_order_details", "product_id='$iId' AND order_id IN (SELECT id FROM tbl_orders WHERE FIND_IN_SET(shippment_status, 'P,C,R'))")),

Thanks.

  • 1 Contributor
  • 1 Reply
  • 115 Views
  • 21 Hours Discussion Span
  • Latest Post Latest Post by Sikander Nasar
Member Avatar for Sikander Nasar

Not anyone to solve this tricky problem?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.