01.function editPayment($payment_id)
02. {
03. $obj = new mainClass();
04. $con = $obj->connectDB();
05.
06. $sql = "SELECT * FROM affiated_sale_for_banners WHERE order_id='$payment_id'";
07. $result = $obj->queryData($sql);
08. $row = $result->num_rows;
09.
10. if($row > 0)
11. {
12.
13. $sql = "UPDATE orders, affiated_sale_for_banners SET orders.payment_status = 2 affiated_sale_for_banners.payment_status = 2 WHERE orders.order_id='$payment_id' AND affiated_sale_for_banners.order_id='$payment_id'";
14. $result = $obj->queryData($sql);
15. }
16. else
17. {
18. $sql = "UPDATE orders SET payment_status = 2 WHERE order_id='$payment_id'";
19. $result = $obj->queryData($sql);
20. }
21.
22.
23. }
Load balance : Server 04
