Count number of a product sold in x days

Code: Select all

SELECT sum(op.quantity) AS total FROM order_product op LEFT JOIN `order` o ON (op.order_id = o.order_id) WHERE product_id=257 AND DATE(date_added) >= CURDATE()-INTERVAL 1 MONTH;

Code: Select all

public function totalsold30days(){
				$query = "I CANT SEEM TO POST WITHOUT REMOVING the ACTUAL SQL QUERY HERE BUT IT'S ABOVE ANYWAY";
				return $this->db->query($query);
				}

Code: Select all

				public function totalsold30days() {
				$this -> data ['sold30'] = $this -> model_catalog_product -> totalsold30days();
				}	

Code: Select all

public function totalsold30days(){
            $query = $this->db->query("SELECT sum(op.quantity) AS total FROM order_product op LEFT JOIN `order` o ON (op.order_id = o.order_id) WHERE product_id=257 AND DATE(date_added) >= CURDATE()-INTERVAL 1 MONTH");

            return $query->row['total'];
            }

Code: Select all

foreach ($results as $result) { //index 1
..etc
//public function totalsold30days() { //remove
 $this -> data ['sold30'] = $this -> model_catalog_product -> totalsold30days($result['product_id']);
//}   //remove
... etc

Code: Select all

public function totalsold30days($product_id){
            $query = $this->db->query("SELECT sum(op.quantity) AS total FROM order_product op LEFT JOIN `order` o ON (op.order_id = o.order_id) WHERE product_id='" . (int)$product_id . "' AND DATE(date_added) >= CURDATE()-INTERVAL 1 MONTH");

            return $query->row['total'];
            }