Is there a way that i can use the order_option -> product_option_id to get the EAN code from the product_option_value table within this function? (i have installed a mod to add the EAN to the product_option _value table)
Can anyone help me to find a best practice method to solve this callenge?
Thanks!public function getOrderOptions($order_id, $order_product_id) {
$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "order_option WHERE order_id = '" . (int)$order_id . "' AND order_product_id = '" . (int)$order_product_id . "'");
// Get option EAN from product_option_value table by product_option_value_id
return $query->rows;
}