Advertisement
Guest User

Untitled

a guest
Oct 31st, 2021
436
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.60 KB | None | 0 0
  1.         $query = "SELECT model_id, model, pass_price, partial_pass_price, fail_price FROM models";
  2.         $result = $this->db->query($query)->getResult();
  3.         foreach ($result as $row) {
  4.             $query = "SELECT order_id, model_id, quantity, pass_quantity, partial_pass_quantity, fail_quantity, pass_price, partial_pass_price, fail_price, model FROM order_items JOIN models ON models.model_id = order_items.model_id WHERE models.model = ('{$row->model}') AND order_items.order_id = $order_id ORDER BY models.model";
  5.             $array[] = $result = $this->db->query($query)->getResult();
  6.         }
  7.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement