Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $query = "SELECT model_id, model, pass_price, partial_pass_price, fail_price FROM models";
- $result = $this->db->query($query)->getResult();
- foreach ($result as $row) {
- $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";
- $array[] = $result = $this->db->query($query)->getResult();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement