PC
Size: a a a
PC
HH
PC
HH
HH
PC
HH
PC
HH
PC
HH
DM
HH
HH
HH
DM
HH
HH
HH
DS
public function getMinPriceFromCategory($category_id)
{
$sql = "SELECT MIN(price) as min_price FROM " . DB_PREFIX . "product p
LEFT JOIN " . DB_PREFIX . "product_to_category p2c ON p.product_id = p2c.product_id
WHERE p2c.category_id = " . (int)$category_id;
$query = $this->db->query($sql);
$min_price = $query->row['min_price'];
return $min_price;
}