Code: Select all
public function getTotalProductsByCategoryId($category_id = 0) {
$sql = "SELECT DISTINCT p2c.product_id FROM " . DB_PREFIX . "product_to_category p2c LEFT JOIN " . DB_PREFIX . "product p ON (p2c.product_id = p.product_id) LEFT JOIN " . DB_PREFIX . "stock_status ss ON (p.stock_status_id = ss.stock_status_id) WHERE p.status = '1' AND p.date_available <= NOW() AND p2c.category_id = '" . (int)$category_id . "'";
$query = $this->db->query( $sql );
return count($query->rows);
}
