Get a single value from a a database ?

[eluser]n0xie[/eluser]

Code:

$this->db->select('product_name');
  $this->db->where("product_id", "10");
  $this->db->limit(1);
  $query = $this->db->get('products');
  
  echo $query->row()->product_name;